2025-06-04 01:19:29,911 [ 348503 ] INFO : ClickHouse root is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse (runner:42, check_args_and_update_paths) 2025-06-04 01:19:29,911 [ 348503 ] INFO : Cases dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:86, check_args_and_update_paths) 2025-06-04 01:19:29,912 [ 348503 ] INFO : utils dir is not set. Will use /home/ubuntu/_work/ClickHouse/ClickHouse/utils (runner:97, check_args_and_update_paths) 2025-06-04 01:19:29,912 [ 348503 ] INFO : base_configs_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/programs/server, binary: /home/ubuntu/_work/_temp/test/build/clickhouse, cases_dir: /home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration (runner:99, check_args_and_update_paths) clickhouse_integration_tests_volume Running pytest container as: 'docker run --rm --name clickhouse_integration_tests_62y5ue --privileged --dns-search='.' --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=2cffe1eae894 -e DOCKER_BASE_TAG=2993bc2bf171 -e DOCKER_KERBERIZED_HADOOP_TAG=ce74919e88f5 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=a2d3dc777d0c -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_postgresql_replica_database_engine_1/test.py::test_replicating_dml test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished test_postgresql_replica_database_engine_1/test.py::test_single_transaction test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots test_postgresql_replica_database_engine_1/test.py::test_virtual_columns test_quota/test.py::test_add_remove_interval test_quota/test.py::test_add_remove_quota test_quota/test.py::test_consumption_of_show_clusters test_quota/test.py::test_consumption_of_show_databases test_quota/test.py::test_consumption_of_show_privileges test_quota/test.py::test_consumption_of_show_processlist test_quota/test.py::test_consumption_of_show_tables test_quota/test.py::test_dcl_introspection test_quota/test.py::test_dcl_management test_quota/test.py::test_exceed_quota test_quota/test.py::test_query_inserts test_quota/test.py::test_quota_from_users_xml test_quota/test.py::test_reload_users_xml_by_timer test_quota/test.py::test_simpliest_quota test_quota/test.py::test_tracking_quota test_quota/test.py::test_users_xml_is_readonly test_reloading_settings_from_users_xml/test.py::test_force_reload test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout test_render_log_file_name_templates/test.py::test_check_file_names test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 'test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16]' 'test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12]' test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity test_replicated_mutations/test.py::test_mutations 'test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0]' 'test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1]' test_replicated_user_defined_functions/test.py::test_create_and_drop 'test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1]' 'test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0]' test_replicated_user_defined_functions/test.py::test_create_and_replace test_replicated_user_defined_functions/test.py::test_drop_if_exists test_replicated_user_defined_functions/test.py::test_reload_zookeeper test_replicated_user_defined_functions/test.py::test_replication test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation test_replicated_user_defined_functions/test.py::test_server_restart test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 'test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA]' 'test_replicated_users/test.py::test_create_and_delete_replicated[ROLE]' 'test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_and_delete_replicated[USER]' 'test_replicated_users/test.py::test_create_replicated[QUOTA]' 'test_replicated_users/test.py::test_create_replicated[ROLE]' 'test_replicated_users/test.py::test_create_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated[USER]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[USER]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER]' 'test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster]' 'test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster]' test_replicated_users/test.py::test_reload_zookeeper 'test_replicated_users/test.py::test_rename_replicated[QUOTA]' 'test_replicated_users/test.py::test_rename_replicated[ROLE]' 'test_replicated_users/test.py::test_rename_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_rename_replicated[USER]' test_replicating_constants/test.py::test_different_versions test_replication_credentials/test.py::test_credentials_and_no_credentials test_replication_credentials/test.py::test_different_credentials test_replication_credentials/test.py::test_no_credentials test_replication_credentials/test.py::test_same_credentials test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss test_s3_imds/test_session_token.py::test_credentials_from_metadata 'test_s3_with_https/test.py::test_s3_with_https[s3_secure]' 'test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy]' test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries test_ssh_keys_authentication/test.py::test_ecdsa test_ssh_keys_authentication/test.py::test_ed25519 test_ssh_keys_authentication/test.py::test_key_with_passphrase test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase -vvv" altinityinfra/integration-tests-runner:9d492c2eec24 '. Start tests ============================= test session starts ============================== platform linux -- Python 3.10.12, pytest-7.4.4, pluggy-1.5.0 -- /usr/bin/python3 cachedir: .pytest_cache rootdir: /ClickHouse/tests/integration configfile: pytest.ini plugins: order-1.0.1, random-0.2, timeout-2.2.0, repeat-0.9.3, reportlog-0.4.0, xdist-3.5.0 timeout: 900.0s timeout method: signal timeout func_only: False created: 10/10 workers 10 workers [100 items] scheduling tests via LoadFileScheduling test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper test_postgresql_replica_database_engine_1/test.py::test_replicating_dml test_quota/test.py::test_add_remove_interval test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table test_reloading_settings_from_users_xml/test.py::test_force_reload test_replicated_user_defined_functions/test.py::test_create_and_drop test_replicated_mutations/test.py::test_mutations test_replication_credentials/test.py::test_credentials_and_no_credentials test_ssh_keys_authentication/test.py::test_ecdsa [gw6] [ 1%] PASSED test_ssh_keys_authentication/test.py::test_ecdsa test_ssh_keys_authentication/test.py::test_ed25519 [gw6] [ 2%] PASSED test_ssh_keys_authentication/test.py::test_ed25519 test_ssh_keys_authentication/test.py::test_key_with_passphrase [gw6] [ 3%] PASSED test_ssh_keys_authentication/test.py::test_key_with_passphrase test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase [gw6] [ 4%] PASSED test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase [gw4] [ 5%] PASSED test_reloading_settings_from_users_xml/test.py::test_force_reload test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout test_s3_with_https/test.py::test_s3_with_https[s3_secure] [gw3] [ 6%] FAILED test_postgresql_replica_database_engine_1/test.py::test_replicating_dml [gw0] [ 7%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] [gw2] [ 8%] PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] [gw0] [ 9%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished [gw4] [ 10%] PASSED test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum [gw2] [ 11%] PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] [gw0] [ 12%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] [gw0] [ 13%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_and_delete_replicated[USER] [gw0] [ 14%] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[USER] test_replicated_users/test.py::test_create_replicated[QUOTA] [gw2] [ 15%] PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] test_replicated_user_defined_functions/test.py::test_create_and_replace [gw1] [ 16%] PASSED test_quota/test.py::test_add_remove_interval test_quota/test.py::test_add_remove_quota [gw4] [ 17%] PASSED test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int [gw0] [ 18%] PASSED test_replicated_users/test.py::test_create_replicated[QUOTA] test_replicated_users/test.py::test_create_replicated[ROLE] [gw2] [ 19%] PASSED test_replicated_user_defined_functions/test.py::test_create_and_replace test_replicated_user_defined_functions/test.py::test_drop_if_exists [gw4] [ 20%] PASSED test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload [gw0] [ 21%] PASSED test_replicated_users/test.py::test_create_replicated[ROLE] test_replicated_users/test.py::test_create_replicated[ROW_POLICY] [gw2] [ 22%] PASSED test_replicated_user_defined_functions/test.py::test_drop_if_exists test_replicated_user_defined_functions/test.py::test_reload_zookeeper [gw5] [ 23%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper [gw0] [ 24%] PASSED test_replicated_users/test.py::test_create_replicated[ROW_POLICY] test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] [gw4] [ 25%] PASSED test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout [gw0] [ 26%] PASSED test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_replicated[USER] [gw0] [ 27%] PASSED test_replicated_users/test.py::test_create_replicated[USER] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] [gw4] [ 28%] PASSED test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout [gw6] [ 29%] PASSED test_s3_with_https/test.py::test_s3_with_https[s3_secure] test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] [gw0] [ 30%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] [gw1] [ 31%] PASSED test_quota/test.py::test_add_remove_quota test_quota/test.py::test_consumption_of_show_clusters [gw0] [ 32%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] [gw6] [ 33%] PASSED test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] [gw0] [ 34%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] [gw1] [ 35%] PASSED test_quota/test.py::test_consumption_of_show_clusters test_quota/test.py::test_consumption_of_show_databases [gw0] [ 36%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] [gw0] [ 37%] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] [gw0] [ 38%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] [gw1] [ 39%] PASSED test_quota/test.py::test_consumption_of_show_databases test_quota/test.py::test_consumption_of_show_privileges [gw0] [ 40%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility [gw5] [ 41%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper [gw5] [ 42%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper [gw0] [ 43%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] [gw1] [ 44%] PASSED test_quota/test.py::test_consumption_of_show_privileges test_quota/test.py::test_consumption_of_show_processlist [gw0] [ 45%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_replicated_on_cluster[USER] [gw0] [ 46%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[USER] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] [gw1] [ 47%] PASSED test_quota/test.py::test_consumption_of_show_processlist test_quota/test.py::test_consumption_of_show_tables [gw0] [ 48%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] [gw1] [ 49%] PASSED test_quota/test.py::test_consumption_of_show_tables test_quota/test.py::test_dcl_introspection [gw3] [ 50%] FAILED test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished test_postgresql_replica_database_engine_1/test.py::test_single_transaction [gw0] [ 51%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] [gw0] [ 52%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] [gw5] [ 53%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity [gw0] [ 54%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] [gw0] [ 55%] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] [gw1] [ 56%] PASSED test_quota/test.py::test_dcl_introspection test_quota/test.py::test_dcl_management [gw5] [ 57%] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity [gw0] [ 58%] PASSED test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] [gw0] [ 59%] PASSED test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] test_replicated_users/test.py::test_reload_zookeeper [gw3] [ 60%] FAILED test_postgresql_replica_database_engine_1/test.py::test_single_transaction test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes [gw8] [ 61%] PASSED test_replication_credentials/test.py::test_credentials_and_no_credentials test_replication_credentials/test.py::test_different_credentials test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 [gw1] [ 62%] PASSED test_quota/test.py::test_dcl_management test_quota/test.py::test_exceed_quota [gw3] [ 63%] FAILED test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots [gw2] [ 64%] PASSED test_replicated_user_defined_functions/test.py::test_reload_zookeeper test_replicated_user_defined_functions/test.py::test_replication [gw8] [ 65%] PASSED test_replication_credentials/test.py::test_different_credentials test_replication_credentials/test.py::test_no_credentials [gw3] [ 66%] FAILED test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots test_render_log_file_name_templates/test.py::test_check_file_names [gw1] [ 67%] PASSED test_quota/test.py::test_exceed_quota test_quota/test.py::test_query_inserts test_postgresql_replica_database_engine_1/test.py::test_virtual_columns [gw2] [ 68%] PASSED test_replicated_user_defined_functions/test.py::test_replication test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation [gw3] [ 69%] FAILED test_postgresql_replica_database_engine_1/test.py::test_virtual_columns [gw2] [ 70%] PASSED test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation test_replicated_user_defined_functions/test.py::test_server_restart [gw8] [ 71%] PASSED test_replication_credentials/test.py::test_no_credentials test_replication_credentials/test.py::test_same_credentials [gw1] [ 72%] PASSED test_quota/test.py::test_query_inserts test_quota/test.py::test_quota_from_users_xml [gw1] [ 73%] PASSED test_quota/test.py::test_quota_from_users_xml test_quota/test.py::test_reload_users_xml_by_timer [gw8] [ 74%] PASSED test_replication_credentials/test.py::test_same_credentials [gw2] [ 75%] PASSED test_replicated_user_defined_functions/test.py::test_server_restart test_replicated_user_defined_functions/test.py::test_start_without_zookeeper [gw1] [ 76%] PASSED test_quota/test.py::test_reload_users_xml_by_timer test_quota/test.py::test_simpliest_quota [gw6] [ 77%] PASSED test_render_log_file_name_templates/test.py::test_check_file_names [gw1] [ 78%] PASSED test_quota/test.py::test_simpliest_quota test_quota/test.py::test_tracking_quota [gw9] [ 79%] PASSED test_replicated_mutations/test.py::test_mutations test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss [gw1] [ 80%] PASSED test_quota/test.py::test_tracking_quota test_quota/test.py::test_users_xml_is_readonly [gw0] [ 81%] PASSED test_replicated_users/test.py::test_reload_zookeeper test_replicated_users/test.py::test_rename_replicated[QUOTA] [gw0] [ 82%] PASSED test_replicated_users/test.py::test_rename_replicated[QUOTA] test_replicated_users/test.py::test_rename_replicated[ROLE] [gw1] [ 83%] PASSED test_quota/test.py::test_users_xml_is_readonly [gw0] [ 84%] PASSED test_replicated_users/test.py::test_rename_replicated[ROLE] test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] [gw0] [ 85%] PASSED test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] [gw0] [ 86%] PASSED test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] test_replicated_users/test.py::test_rename_replicated[USER] [gw0] [ 87%] PASSED test_replicated_users/test.py::test_rename_replicated[USER] [gw4] [ 88%] PASSED test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility [gw7] [ 89%] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] [gw7] [ 90%] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] test_replicating_constants/test.py::test_different_versions test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] [gw7] [ 91%] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore [gw7] [ 92%] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore [gw2] [ 93%] PASSED test_replicated_user_defined_functions/test.py::test_start_without_zookeeper [gw5] [ 94%] PASSED test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 [gw4] [ 95%] PASSED test_replicating_constants/test.py::test_different_versions test_s3_imds/test_session_token.py::test_credentials_from_metadata [gw9] [ 96%] PASSED test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries [gw4] [ 97%] PASSED test_s3_imds/test_session_token.py::test_credentials_from_metadata [gw5] [ 98%] PASSED test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries [gw9] [ 99%] PASSED test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] [gw6] [100%] PASSED test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss =================================== FAILURES =================================== _____________________________ test_replicating_dml _____________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_replicating_dml(started_cluster): NUM_TABLES = 5 for i in range(NUM_TABLES): pg_manager.create_postgres_table(f"postgresql_replica_{i}") instance.query( "INSERT INTO postgres_database.postgresql_replica_{} SELECT number, {} from numbers(50)".format( i, i ) ) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port ) for i in range(NUM_TABLES): instance.query( f"INSERT INTO postgres_database.postgresql_replica_{i} SELECT 50 + number, {i} from numbers(1000)" ) > check_several_tables_are_synchronized(instance, NUM_TABLES) test_postgresql_replica_database_engine_1/test.py:100: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:419: in check_several_tables_are_synchronized check_tables_are_synchronized( helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.2.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000001d2c7fa3 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000efeff34 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x0000000007d33e7c E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x0000000017392aa6 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000001738b92f E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x0000000017386d9a E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000001784d170 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x0000000017849b40 E 8. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:701: std::unique_ptr> std::__function::__policy_invoker> (DB::InterpreterFactory::Arguments const&)>::__call_impl> (DB::InterpreterFactory::Arguments const&)>>(std::__function::__policy_storage const*, DB::InterpreterFactory::Arguments const&) @ 0x000000001784e470 E 9. ./build_docker/./src/Interpreters/InterpreterFactory.cpp:0: DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x00000000177b9ecb E 10. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000017da83ff E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000017da3ef8 E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000195d56b2 E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x00000000195f3d08 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000001d154aa3 E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000001d155312 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x000000001d356fc7 E 17. ./build_docker/./base/poco/Foundation/src/Thread.cpp:46: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x000000001d355290 E 18. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001d35374a E 19. __tsan_thread_start_func @ 0x0000000007068b4f E 20. ? @ 0x00007f1f7b6beac3 E 21. ? @ 0x00007f1f7b750850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- Copy common default production configuration from /clickhouse-config. Files: config.xml, users.xml PostgreSQL is available - running test ---------------------------- Captured stderr setup ----------------------------- Command:['docker ps | wc -l'] Stdout:1 No running containers Pruning Docker networks Command:['docker network prune --force'] Command:["sysctl net.ipv4.ip_local_port_range='55000 65535'"] Stdout:net.ipv4.ip_local_port_range = 55000 65535 Running tests in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/test.py Cluster start called. is_up=False Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME Cleanup called Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine1_.*_1$' --format '{{.ID}}:{{.Names}}' Unstopped containers: {} No running containers for project: roottestpostgresqlreplicadatabaseengine1 Trying to prune unused networks... Trying to prune unused images... Command:['docker', 'image', 'prune', '-f'] Stderr:Error response from daemon: a prune operation is already running Exitcode:1 Trying to prune unused volumes... Command:['docker volume ls | wc -l'] Stdout:1 Setup directory for instance: instance Create directory for configuration generated in this helper Create directory for common tests configuration Copy common configuration from helpers Generate and write macros file Copy custom test config files ['/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/configs/log_conf.xml'] to /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/configs/config.d Setup database dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/database Setup logs dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs Entrypoint cmd: bash -c "trap 'pkill tail' INT TERM; clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon; coproc tail -f /dev/null; wait $$!" Env {'ASAN_OPTIONS': 'use_sigaltstack=0', 'TSAN_OPTIONS': 'use_sigaltstack=0', 'CLICKHOUSE_WATCHDOG_ENABLE': '0', 'CLICKHOUSE_NATS_TLS_SECURE': '0', 'LLVM_PROFILE_FILE': '/var/lib/clickhouse/server_%h_%p_%m.profraw', 'POSTGRES_PORT': '5432', 'POSTGRES_DIR': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'POSTGRES_LOGS_FS': 'bind'} stored in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] No config file found Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] No config file found http://localhost:None "GET /version HTTP/1.1" 200 826 Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'pull'] Stderr:Pulling postgres1 ... Stderr:Pulling instance ... Stderr:Pulling postgres1 ... pulling from library/postgres Stderr:Pulling instance ... pulling from altinityinfra/integr... Stderr:Pulling postgres1 ... digest: sha256:6efd0df010dc3cb40d... Stderr:Pulling postgres1 ... status: image is up to date for p... Stderr:Pulling postgres1 ... done Stderr:Pulling instance ... digest: sha256:8a2c68e2d63d82c826... Stderr:Pulling instance ... status: image is up to date for a... Stderr:Pulling instance ... done Setup Postgres Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', '--verbose', 'up', '-d'] Stderr:compose.config.config.find: Using configuration files: /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml Stderr:compose.cli.docker_client.get_client: docker-compose version 1.29.2, build unknown Stderr:docker-py version: Stderr:CPython version: 3.10.12 Stderr:OpenSSL version: OpenSSL 3.0.2 15 Mar 2022 Stderr:compose.cli.docker_client.get_client: Docker base_url: http+docker://localhost Stderr:compose.cli.docker_client.get_client: Docker version: Platform={'Name': 'Docker Engine - Community'}, Components=[{'Name': 'Engine', 'Version': '23.0.6', 'Details': {'ApiVersion': '1.42', 'Arch': 'amd64', 'BuildTime': '2023-05-05T21:18:13.000000000+00:00', 'Experimental': 'false', 'GitCommit': '9dbdbd4', 'GoVersion': 'go1.19.9', 'KernelVersion': '5.15.0-130-generic', 'MinAPIVersion': '1.12', 'Os': 'linux'}}, {'Name': 'containerd', 'Version': '1.7.18', 'Details': {'GitCommit': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}}, {'Name': 'runc', 'Version': '1.7.18', 'Details': {'GitCommit': 'v1.1.13-0-g58aa920'}}, {'Name': 'docker-init', 'Version': '0.19.0', 'Details': {'GitCommit': 'de40ad0'}}], Version=23.0.6, ApiVersion=1.42, MinAPIVersion=1.12, GitCommit=9dbdbd4, GoVersion=go1.19.9, Os=linux, Arch=amd64, KernelVersion=5.15.0-130-generic, BuildTime=2023-05-05T21:18:13.000000000+00:00 Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine1_default') Stderr:compose.cli.verbose_proxy.proxy_callable: docker info <- () Stderr:compose.cli.verbose_proxy.proxy_callable: docker info -> {'Architecture': 'x86_64', Stderr: 'BridgeNfIp6tables': True, Stderr: 'BridgeNfIptables': True, Stderr: 'CPUSet': True, Stderr: 'CPUShares': True, Stderr: 'CgroupDriver': 'cgroupfs', Stderr: 'CgroupVersion': '2', Stderr: 'ContainerdCommit': {'Expected': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e', Stderr: 'ID': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}, Stderr: 'Containers': 1, Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine1_default') Stderr:compose.network.ensure: Creating network "roottestpostgresqlreplicadatabaseengine1_default" with the default driver Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network <- (name='roottestpostgresqlreplicadatabaseengine1_default', driver=None, options=None, ipam=None, internal=False, enable_ipv6=False, labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.network': 'default', 'com.docker.compose.version': '1.29.2'}, attachable=True, check_duplicate=True) Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network -> {'Id': 'c3e348947ea23537eca7593d2bf05874f550e48f12ae3ab538cca14beafdd784', Stderr: 'Warning': ''} Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', Stderr: 'Author': '', Stderr: 'Comment': 'buildkit.dockerfile.v0', Stderr: 'Config': {'AttachStderr': False, Stderr: 'AttachStdin': False, Stderr: 'AttachStdout': False, Stderr: 'Cmd': ['postgres'], Stderr: 'Domainname': '', Stderr: 'Entrypoint': ['docker-entrypoint.sh'], Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.parallel.feed_queue: Pending: {} Stderr:compose.parallel.feed_queue: Starting producer thread for Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) Stderr:Creating roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... Stderr:compose.parallel.feed_queue: Pending: {ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1)} Stderr:compose.parallel.feed_queue: Starting producer thread for ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1) Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', Stderr: 'Author': '', Stderr: 'Comment': 'buildkit.dockerfile.v0', Stderr: 'Config': {'AttachStderr': False, Stderr: 'AttachStdin': False, Stderr: 'AttachStdout': False, Stderr: 'Cmd': ['postgres'], Stderr: 'Domainname': '', Stderr: 'Entrypoint': ['docker-entrypoint.sh'], Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', Stderr: 'Author': '', Stderr: 'Comment': 'buildkit.dockerfile.v0', Stderr: 'Config': {'AttachStderr': False, Stderr: 'AttachStdin': False, Stderr: 'AttachStdout': False, Stderr: 'Cmd': ['postgres'], Stderr: 'Domainname': '', Stderr: 'Entrypoint': ['docker-entrypoint.sh'], Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', Stderr:... Stderr:compose.service.build_container_labels: Added config hash: 93968ec629d91980ea64eb0c7d74531b9606057f28d2f63fd9c8a6b21e104bb1 Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config <- (links=[], port_bindings={}, binds=[], volumes_from=[], privileged=False, network_mode='roottestpostgresqlreplicadatabaseengine1_default', devices=None, device_requests=None, dns=None, dns_opt=None, dns_search=None, restart_policy={'Name': 'always', 'MaximumRetryCount': 0}, runtime=None, cap_add=None, cap_drop=None, mem_limit=None, mem_reservation=None, memswap_limit=None, ulimits=None, log_config={'Type': '', 'Config': {}}, extra_hosts=None, read_only=None, pid_mode=None, security_opt=None, ipc_mode=None, cgroup_parent=None, cpu_quota=None, shm_size=None, sysctls=None, pids_limit=None, tmpfs=None, oom_kill_disable=None, oom_score_adj=None, mem_swappiness=None, group_add=None, userns_mode=None, init=None, init_path=None, isolation=None, cpu_count=None, cpu_percent=None, nano_cpus=None, volume_driver=None, cpuset_cpus=None, cpu_shares=None, storage_opt=None, blkio_weight=None, blkio_weight_device=None, device_read_bps=None, device_read_iops=None, device_write_bps=None, device_write_iops=None, mounts=[{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}], device_cgroup_rules=None, cpu_period=None, cpu_rt_period=None, cpu_rt_runtime=None) Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config -> {'Binds': [], Stderr: 'Links': [], Stderr: 'LogConfig': {'Config': {}, 'Type': ''}, Stderr: 'Mounts': [{'ReadOnly': None, Stderr: 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', Stderr: 'Target': '/postgres/', Stderr: 'Type': 'bind'}], Stderr: 'NetworkMode': 'roottestpostgresqlreplicadatabaseengine1_default', Stderr: 'PortBindings': {}, Stderr: 'RestartPolicy': {'MaximumRetryCount': 0, 'Name': 'always'}, Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container <- (command=['postgres', '-c', 'wal_level=logical', '-c', 'max_replication_slots=4', '-c', 'logging_collector=on', '-c', 'log_directory=/postgres/logs', '-c', 'log_filename=postgresql.log', '-c', 'log_statement=all', '-c', 'max_connections=200'], environment=['POSTGRES_HOST_AUTH_METHOD=trust', 'POSTGRES_PASSWORD=mysecretpassword', 'PGDATA=/postgres/data'], healthcheck={'test': ['CMD-SHELL', 'pg_isready -U postgres'], 'interval': 10000000000, 'timeout': 5000000000, 'retries': 5}, image='postgres', volumes={}, name='roottestpostgresqlreplicadatabaseengine1_postgres1_1', detach=True, ports=['5432'], labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service': 'postgres1', 'com.docker.compose.oneoff': 'False', 'com.docker.compose.project.working_dir': '/ClickHouse/tests/integration/compose', 'com.docker.compose.project.config_files': '/ClickHouse/tests/integration/compose/docker_compose_postgres.yml', 'com.docker.compose.project.environment_file': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', 'com.docker.compose.container-number': '1', 'com.docker.compose.version': '1.29.2', 'com.docker.compose.config-hash': '93968ec629d91980ea64eb0c7d74531b9606057f28d2f63fd9c8a6b21e104bb1'}, host_config={'NetworkMode': 'roottestpostgresqlreplicadatabaseengine1_default', 'RestartPolicy': {'Name': 'always', 'MaximumRetryCount': 0}, 'VolumesFrom': [], 'Binds': [], 'PortBindings': {}, 'Links': [], 'LogConfig': {'Type': '', 'Config': {}}, 'Mounts': [{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}]}, networking_config={'EndpointsConfig': {'roottestpostgresqlreplicadatabaseengine1_default': {'Aliases': ['postgre-sql.local', 'postgres1'], 'IPAMConfig': {}}}}) Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container -> {'Id': 'f59fbbf7803a85858c7014e71056a52f4e2dba24298b6f849d5def6a2065796c', Stderr: 'Warnings': []} Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container <- ('f59fbbf7803a85858c7014e71056a52f4e2dba24298b6f849d5def6a2065796c') Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container -> {'AppArmorProfile': '', Stderr: 'Args': ['postgres', Stderr: '-c', Stderr: 'wal_level=logical', Stderr: '-c', Stderr: 'max_replication_slots=4', Stderr: '-c', Stderr: 'logging_collector=on', Stderr: '-c', Stderr: 'log_directory=/postgres/logs', Stderr:... Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network <- ('f59fbbf7803a85858c7014e71056a52f4e2dba24298b6f849d5def6a2065796c', 'roottestpostgresqlreplicadatabaseengine1_default') Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network -> None Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network <- ('f59fbbf7803a85858c7014e71056a52f4e2dba24298b6f849d5def6a2065796c', 'roottestpostgresqlreplicadatabaseengine1_default', aliases=['f59fbbf7803a', 'postgre-sql.local', 'postgres1'], ipv4_address=None, ipv6_address=None, links=[], link_local_ips=None) Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network -> None Stderr:compose.cli.verbose_proxy.proxy_callable: docker start <- ('f59fbbf7803a85858c7014e71056a52f4e2dba24298b6f849d5def6a2065796c') Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.cli.verbose_proxy.proxy_callable: docker start -> None Stderr:compose.parallel.parallel_execute_iter: Finished processing: ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1) Stderr:Creating roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done Stderr:compose.parallel.feed_queue: Pending: set() Stderr:compose.parallel.parallel_execute_iter: Finished processing: Stderr:compose.parallel.feed_queue: Pending: set() get_instance_ip instance_name=postgres1 http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_postgres1_1/json HTTP/1.1" 200 None Can't connect to Postgres connection to server at "172.16.2.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? Can't connect to Postgres connection to server at "172.16.2.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? Can't connect to Postgres connection to server at "172.16.2.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? Postgres Started ('Trying to create ClickHouse instance by command %s', 'docker-compose --env-file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env --project-name roottestpostgresqlreplicadatabaseengine1 --file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml up -d --no-recreate') Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'up', '-d', '--no-recreate'] Stderr:Creating roottestpostgresqlreplicadatabaseengine1_instance_1 ... Stderr:Creating roottestpostgresqlreplicadatabaseengine1_instance_1 ... done ClickHouse instance created get_instance_ip instance_name=instance http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_instance_1/json HTTP/1.1" 200 None Waiting for ClickHouse start in instance, ip: 172.16.2.3... http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_instance_1/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None ClickHouse instance started Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ------------------------------ Captured log setup ------------------------------ 2025-06-04 01:19:33 [ 515 ] DEBUG : Command:['docker ps | wc -l'] (cluster.py:113, run_and_check) 2025-06-04 01:19:33 [ 515 ] DEBUG : Stdout:1 (cluster.py:121, run_and_check) 2025-06-04 01:19:33 [ 515 ] DEBUG : No running containers (conftest.py:92, cleanup_environment) 2025-06-04 01:19:33 [ 515 ] DEBUG : Pruning Docker networks (conftest.py:94, cleanup_environment) 2025-06-04 01:19:33 [ 515 ] DEBUG : Command:['docker network prune --force'] (cluster.py:113, run_and_check) 2025-06-04 01:19:33 [ 515 ] DEBUG : Command:["sysctl net.ipv4.ip_local_port_range='55000 65535'"] (cluster.py:113, run_and_check) 2025-06-04 01:19:33 [ 515 ] DEBUG : Stdout:net.ipv4.ip_local_port_range = 55000 65535 (cluster.py:121, run_and_check) 2025-06-04 01:19:33 [ 515 ] INFO : Running tests in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/test.py (cluster.py:2659, start) 2025-06-04 01:19:33 [ 515 ] DEBUG : Cluster start called. is_up=False (cluster.py:2666, start) 2025-06-04 01:19:33 [ 515 ] DEBUG : Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:780, print_all_docker_pieces) 2025-06-04 01:19:33 [ 515 ] DEBUG : Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:788, print_all_docker_pieces) 2025-06-04 01:19:33 [ 515 ] DEBUG : Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME (cluster.py:796, print_all_docker_pieces) 2025-06-04 01:19:33 [ 515 ] DEBUG : Cleanup called (cluster.py:801, cleanup) 2025-06-04 01:19:33 [ 515 ] DEBUG : Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:780, print_all_docker_pieces) 2025-06-04 01:19:33 [ 515 ] DEBUG : Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:788, print_all_docker_pieces) 2025-06-04 01:19:33 [ 515 ] DEBUG : Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME (cluster.py:796, print_all_docker_pieces) 2025-06-04 01:19:33 [ 515 ] DEBUG : Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine1_.*_1$' --format '{{.ID}}:{{.Names}}' (cluster.py:113, run_and_check) 2025-06-04 01:19:33 [ 515 ] DEBUG : Unstopped containers: {} (cluster.py:815, cleanup) 2025-06-04 01:19:33 [ 515 ] DEBUG : No running containers for project: roottestpostgresqlreplicadatabaseengine1 (cluster.py:829, cleanup) 2025-06-04 01:19:33 [ 515 ] DEBUG : Trying to prune unused networks... (cluster.py:835, cleanup) 2025-06-04 01:19:33 [ 515 ] DEBUG : Trying to prune unused images... (cluster.py:851, cleanup) 2025-06-04 01:19:33 [ 515 ] DEBUG : Command:['docker', 'image', 'prune', '-f'] (cluster.py:113, run_and_check) 2025-06-04 01:19:33 [ 515 ] DEBUG : Stderr:Error response from daemon: a prune operation is already running (cluster.py:123, run_and_check) 2025-06-04 01:19:33 [ 515 ] DEBUG : Exitcode:1 (cluster.py:125, run_and_check) 2025-06-04 01:19:33 [ 515 ] DEBUG : Trying to prune unused volumes... (cluster.py:860, cleanup) 2025-06-04 01:19:33 [ 515 ] DEBUG : Command:['docker volume ls | wc -l'] (cluster.py:113, run_and_check) 2025-06-04 01:19:33 [ 515 ] DEBUG : Stdout:1 (cluster.py:121, run_and_check) 2025-06-04 01:19:33 [ 515 ] DEBUG : Setup directory for instance: instance (cluster.py:2679, start) 2025-06-04 01:19:33 [ 515 ] DEBUG : Create directory for configuration generated in this helper (cluster.py:4383, create_dir) 2025-06-04 01:19:33 [ 515 ] DEBUG : Create directory for common tests configuration (cluster.py:4388, create_dir) 2025-06-04 01:19:33 [ 515 ] DEBUG : Copy common configuration from helpers (cluster.py:4408, create_dir) 2025-06-04 01:19:33 [ 515 ] DEBUG : Generate and write macros file (cluster.py:4441, create_dir) 2025-06-04 01:19:33 [ 515 ] DEBUG : Copy custom test config files ['/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/configs/log_conf.xml'] to /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/configs/config.d (cluster.py:4471, create_dir) 2025-06-04 01:19:33 [ 515 ] DEBUG : Setup database dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/database (cluster.py:4488, create_dir) 2025-06-04 01:19:33 [ 515 ] DEBUG : Setup logs dir /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs (cluster.py:4499, create_dir) 2025-06-04 01:19:33 [ 515 ] DEBUG : Entrypoint cmd: bash -c "trap 'pkill tail' INT TERM; clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon; coproc tail -f /dev/null; wait $$!" (cluster.py:4582, create_dir) 2025-06-04 01:19:33 [ 515 ] DEBUG : Env {'ASAN_OPTIONS': 'use_sigaltstack=0', 'TSAN_OPTIONS': 'use_sigaltstack=0', 'CLICKHOUSE_WATCHDOG_ENABLE': '0', 'CLICKHOUSE_NATS_TLS_SECURE': '0', 'LLVM_PROFILE_FILE': '/var/lib/clickhouse/server_%h_%p_%m.profraw', 'POSTGRES_PORT': '5432', 'POSTGRES_DIR': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'POSTGRES_LOGS_FS': 'bind'} stored in /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env (cluster.py:86, _create_env_file) 2025-06-04 01:19:33 [ 515 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-06-04 01:19:33 [ 515 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-06-04 01:19:33 [ 515 ] DEBUG : Trying paths: ['/root/.docker/config.json', '/root/.dockercfg'] (config.py:21, find_config_file) 2025-06-04 01:19:33 [ 515 ] DEBUG : No config file found (config.py:28, find_config_file) 2025-06-04 01:19:33 [ 515 ] DEBUG : http://localhost:None "GET /version HTTP/1.1" 200 826 (connectionpool.py:546, _make_request) 2025-06-04 01:19:33 [ 515 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'pull'] (cluster.py:113, run_and_check) 2025-06-04 01:19:44 [ 515 ] DEBUG : Stderr:Pulling postgres1 ... (cluster.py:123, run_and_check) 2025-06-04 01:19:44 [ 515 ] DEBUG : Stderr:Pulling instance ... (cluster.py:123, run_and_check) 2025-06-04 01:19:44 [ 515 ] DEBUG : Stderr:Pulling postgres1 ... pulling from library/postgres (cluster.py:123, run_and_check) 2025-06-04 01:19:44 [ 515 ] DEBUG : Stderr:Pulling instance ... pulling from altinityinfra/integr... (cluster.py:123, run_and_check) 2025-06-04 01:19:44 [ 515 ] DEBUG : Stderr:Pulling postgres1 ... digest: sha256:6efd0df010dc3cb40d... (cluster.py:123, run_and_check) 2025-06-04 01:19:44 [ 515 ] DEBUG : Stderr:Pulling postgres1 ... status: image is up to date for p... (cluster.py:123, run_and_check) 2025-06-04 01:19:44 [ 515 ] DEBUG : Stderr:Pulling postgres1 ... done (cluster.py:123, run_and_check) 2025-06-04 01:19:44 [ 515 ] DEBUG : Stderr:Pulling instance ... digest: sha256:8a2c68e2d63d82c826... (cluster.py:123, run_and_check) 2025-06-04 01:19:44 [ 515 ] DEBUG : Stderr:Pulling instance ... status: image is up to date for a... (cluster.py:123, run_and_check) 2025-06-04 01:19:44 [ 515 ] DEBUG : Stderr:Pulling instance ... done (cluster.py:123, run_and_check) 2025-06-04 01:19:44 [ 515 ] DEBUG : Setup Postgres (cluster.py:2791, start) 2025-06-04 01:19:44 [ 515 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', '--verbose', 'up', '-d'] (cluster.py:113, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.config.config.find: Using configuration files: /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.docker_client.get_client: docker-compose version 1.29.2, build unknown (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:docker-py version: (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:CPython version: 3.10.12 (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:OpenSSL version: OpenSSL 3.0.2 15 Mar 2022 (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.docker_client.get_client: Docker base_url: http+docker://localhost (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.docker_client.get_client: Docker version: Platform={'Name': 'Docker Engine - Community'}, Components=[{'Name': 'Engine', 'Version': '23.0.6', 'Details': {'ApiVersion': '1.42', 'Arch': 'amd64', 'BuildTime': '2023-05-05T21:18:13.000000000+00:00', 'Experimental': 'false', 'GitCommit': '9dbdbd4', 'GoVersion': 'go1.19.9', 'KernelVersion': '5.15.0-130-generic', 'MinAPIVersion': '1.12', 'Os': 'linux'}}, {'Name': 'containerd', 'Version': '1.7.18', 'Details': {'GitCommit': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}}, {'Name': 'runc', 'Version': '1.7.18', 'Details': {'GitCommit': 'v1.1.13-0-g58aa920'}}, {'Name': 'docker-init', 'Version': '0.19.0', 'Details': {'GitCommit': 'de40ad0'}}], Version=23.0.6, ApiVersion=1.42, MinAPIVersion=1.12, GitCommit=9dbdbd4, GoVersion=go1.19.9, Os=linux, Arch=amd64, KernelVersion=5.15.0-130-generic, BuildTime=2023-05-05T21:18:13.000000000+00:00 (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine1_default') (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker info <- () (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker info -> {'Architecture': 'x86_64', (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'BridgeNfIp6tables': True, (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'BridgeNfIptables': True, (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'CPUSet': True, (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'CPUShares': True, (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'CgroupDriver': 'cgroupfs', (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'CgroupVersion': '2', (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'ContainerdCommit': {'Expected': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e', (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'ID': 'ae71819c4f5e67bb4d5ae76a6b735f29cc25774e'}, (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'Containers': 1, (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_network <- ('roottestpostgresqlreplicadatabaseengine1_default') (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.network.ensure: Creating network "roottestpostgresqlreplicadatabaseengine1_default" with the default driver (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network <- (name='roottestpostgresqlreplicadatabaseengine1_default', driver=None, options=None, ipam=None, internal=False, enable_ipv6=False, labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.network': 'default', 'com.docker.compose.version': '1.29.2'}, attachable=True, check_duplicate=True) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_network -> {'Id': 'c3e348947ea23537eca7593d2bf05874f550e48f12ae3ab538cca14beafdd784', (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'Warning': ''} (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=False, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'Author': '', (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'Comment': 'buildkit.dockerfile.v0', (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'Config': {'AttachStderr': False, (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'AttachStdin': False, (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'AttachStdout': False, (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'Cmd': ['postgres'], (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'Domainname': '', (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'Entrypoint': ['docker-entrypoint.sh'], (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: {} (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.parallel.feed_queue: Starting producer thread for (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers <- (all=True, filters={'label': ['com.docker.compose.project=roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service=postgres1', 'com.docker.compose.oneoff=False']}) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker containers -> (list with 0 items) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: {ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1)} (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.parallel.feed_queue: Starting producer thread for ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1) (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'Author': '', (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'Comment': 'buildkit.dockerfile.v0', (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'Config': {'AttachStderr': False, (cluster.py:123, run_and_check) 2025-06-04 01:19:45 [ 515 ] DEBUG : Stderr: 'AttachStdin': False, (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'AttachStdout': False, (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Cmd': ['postgres'], (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Domainname': '', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Entrypoint': ['docker-entrypoint.sh'], (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image <- ('postgres') (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_image -> {'Architecture': 'amd64', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Author': '', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Comment': 'buildkit.dockerfile.v0', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Config': {'AttachStderr': False, (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'AttachStdin': False, (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'AttachStdout': False, (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Cmd': ['postgres'], (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Domainname': '', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Entrypoint': ['docker-entrypoint.sh'], (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Env': ['PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/lib/postgresql/17/bin', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.service.build_container_labels: Added config hash: 93968ec629d91980ea64eb0c7d74531b9606057f28d2f63fd9c8a6b21e104bb1 (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config <- (links=[], port_bindings={}, binds=[], volumes_from=[], privileged=False, network_mode='roottestpostgresqlreplicadatabaseengine1_default', devices=None, device_requests=None, dns=None, dns_opt=None, dns_search=None, restart_policy={'Name': 'always', 'MaximumRetryCount': 0}, runtime=None, cap_add=None, cap_drop=None, mem_limit=None, mem_reservation=None, memswap_limit=None, ulimits=None, log_config={'Type': '', 'Config': {}}, extra_hosts=None, read_only=None, pid_mode=None, security_opt=None, ipc_mode=None, cgroup_parent=None, cpu_quota=None, shm_size=None, sysctls=None, pids_limit=None, tmpfs=None, oom_kill_disable=None, oom_score_adj=None, mem_swappiness=None, group_add=None, userns_mode=None, init=None, init_path=None, isolation=None, cpu_count=None, cpu_percent=None, nano_cpus=None, volume_driver=None, cpuset_cpus=None, cpu_shares=None, storage_opt=None, blkio_weight=None, blkio_weight_device=None, device_read_bps=None, device_read_iops=None, device_write_bps=None, device_write_iops=None, mounts=[{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}], device_cgroup_rules=None, cpu_period=None, cpu_rt_period=None, cpu_rt_runtime=None) (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_host_config -> {'Binds': [], (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Links': [], (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'LogConfig': {'Config': {}, 'Type': ''}, (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Mounts': [{'ReadOnly': None, (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Target': '/postgres/', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Type': 'bind'}], (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'NetworkMode': 'roottestpostgresqlreplicadatabaseengine1_default', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'PortBindings': {}, (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'RestartPolicy': {'MaximumRetryCount': 0, 'Name': 'always'}, (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container <- (command=['postgres', '-c', 'wal_level=logical', '-c', 'max_replication_slots=4', '-c', 'logging_collector=on', '-c', 'log_directory=/postgres/logs', '-c', 'log_filename=postgresql.log', '-c', 'log_statement=all', '-c', 'max_connections=200'], environment=['POSTGRES_HOST_AUTH_METHOD=trust', 'POSTGRES_PASSWORD=mysecretpassword', 'PGDATA=/postgres/data'], healthcheck={'test': ['CMD-SHELL', 'pg_isready -U postgres'], 'interval': 10000000000, 'timeout': 5000000000, 'retries': 5}, image='postgres', volumes={}, name='roottestpostgresqlreplicadatabaseengine1_postgres1_1', detach=True, ports=['5432'], labels={'com.docker.compose.project': 'roottestpostgresqlreplicadatabaseengine1', 'com.docker.compose.service': 'postgres1', 'com.docker.compose.oneoff': 'False', 'com.docker.compose.project.working_dir': '/ClickHouse/tests/integration/compose', 'com.docker.compose.project.config_files': '/ClickHouse/tests/integration/compose/docker_compose_postgres.yml', 'com.docker.compose.project.environment_file': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', 'com.docker.compose.container-number': '1', 'com.docker.compose.version': '1.29.2', 'com.docker.compose.config-hash': '93968ec629d91980ea64eb0c7d74531b9606057f28d2f63fd9c8a6b21e104bb1'}, host_config={'NetworkMode': 'roottestpostgresqlreplicadatabaseengine1_default', 'RestartPolicy': {'Name': 'always', 'MaximumRetryCount': 0}, 'VolumesFrom': [], 'Binds': [], 'PortBindings': {}, 'Links': [], 'LogConfig': {'Type': '', 'Config': {}}, 'Mounts': [{'Target': '/postgres/', 'Source': '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/postgres/postgres1', 'Type': 'bind', 'ReadOnly': None}]}, networking_config={'EndpointsConfig': {'roottestpostgresqlreplicadatabaseengine1_default': {'Aliases': ['postgre-sql.local', 'postgres1'], 'IPAMConfig': {}}}}) (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker create_container -> {'Id': 'f59fbbf7803a85858c7014e71056a52f4e2dba24298b6f849d5def6a2065796c', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Warnings': []} (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container <- ('f59fbbf7803a85858c7014e71056a52f4e2dba24298b6f849d5def6a2065796c') (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker inspect_container -> {'AppArmorProfile': '', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'Args': ['postgres', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: '-c', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'wal_level=logical', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: '-c', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'max_replication_slots=4', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: '-c', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'logging_collector=on', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: '-c', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr: 'log_directory=/postgres/logs', (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:... (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network <- ('f59fbbf7803a85858c7014e71056a52f4e2dba24298b6f849d5def6a2065796c', 'roottestpostgresqlreplicadatabaseengine1_default') (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker disconnect_container_from_network -> None (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network <- ('f59fbbf7803a85858c7014e71056a52f4e2dba24298b6f849d5def6a2065796c', 'roottestpostgresqlreplicadatabaseengine1_default', aliases=['f59fbbf7803a', 'postgre-sql.local', 'postgres1'], ipv4_address=None, ipv6_address=None, links=[], link_local_ips=None) (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker connect_container_to_network -> None (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker start <- ('f59fbbf7803a85858c7014e71056a52f4e2dba24298b6f849d5def6a2065796c') (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.cli.verbose_proxy.proxy_callable: docker start -> None (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.parallel.parallel_execute_iter: Finished processing: ServiceName(project='roottestpostgresqlreplicadatabaseengine1', service='postgres1', number=1) (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.parallel.parallel_execute_iter: Finished processing: (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : Stderr:compose.parallel.feed_queue: Pending: set() (cluster.py:123, run_and_check) 2025-06-04 01:19:46 [ 515 ] DEBUG : get_instance_ip instance_name=postgres1 (cluster.py:2008, get_instance_ip) 2025-06-04 01:19:46 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_postgres1_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:46 [ 515 ] DEBUG : Can't connect to Postgres connection to server at "172.16.2.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? (cluster.py:2251, wait_postgres_to_start) 2025-06-04 01:19:46 [ 515 ] DEBUG : Can't connect to Postgres connection to server at "172.16.2.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? (cluster.py:2251, wait_postgres_to_start) 2025-06-04 01:19:47 [ 515 ] DEBUG : Can't connect to Postgres connection to server at "172.16.2.2", port 5432 failed: Connection refused Is the server running on that host and accepting TCP/IP connections? (cluster.py:2251, wait_postgres_to_start) 2025-06-04 01:19:47 [ 515 ] DEBUG : Postgres Started (cluster.py:2248, wait_postgres_to_start) 2025-06-04 01:19:47 [ 515 ] DEBUG : ('Trying to create ClickHouse instance by command %s', 'docker-compose --env-file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env --project-name roottestpostgresqlreplicadatabaseengine1 --file /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml --file /ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml up -d --no-recreate') (cluster.py:3002, start) 2025-06-04 01:19:47 [ 515 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'up', '-d', '--no-recreate'] (cluster.py:113, run_and_check) 2025-06-04 01:19:48 [ 515 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine1_instance_1 ... (cluster.py:123, run_and_check) 2025-06-04 01:19:48 [ 515 ] DEBUG : Stderr:Creating roottestpostgresqlreplicadatabaseengine1_instance_1 ... done (cluster.py:123, run_and_check) 2025-06-04 01:19:48 [ 515 ] DEBUG : ClickHouse instance created (cluster.py:3010, start) 2025-06-04 01:19:48 [ 515 ] DEBUG : get_instance_ip instance_name=instance (cluster.py:2008, get_instance_ip) 2025-06-04 01:19:48 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_instance_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:48 [ 515 ] DEBUG : Waiting for ClickHouse start in instance, ip: 172.16.2.3... (cluster.py:3017, start) 2025-06-04 01:19:48 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/roottestpostgresqlreplicadatabaseengine1_instance_1/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:48 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:48 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:48 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:48 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:48 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:48 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:48 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:48 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:48 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:49 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:49 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:49 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:49 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:49 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:49 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:49 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:49 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:49 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:49 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:50 [ 515 ] DEBUG : http://localhost:None "GET /v1.42/containers/7d0cda5ff9c1c9f64c893174bf2ddf8f4dd548002424e48f4a8f10f718298a22/json HTTP/1.1" 200 None (connectionpool.py:546, _make_request) 2025-06-04 01:19:50 [ 515 ] DEBUG : ClickHouse instance started (cluster.py:3021, start) 2025-06-04 01:19:50 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:19:50 [ 515 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_1" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_2" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_3" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_4" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, 0 from numbers(50) on instance Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT number, 1 from numbers(50) on instance Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT number, 2 from numbers(50) on instance Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT number, 3 from numbers(50) on instance Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT number, 4 from numbers(50) on instance Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT 50 + number, 0 from numbers(1000) on instance Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT 50 + number, 1 from numbers(1000) on instance Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT 50 + number, 2 from numbers(1000) on instance Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT 50 + number, 3 from numbers(1000) on instance Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT 50 + number, 4 from numbers(1000) on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-04 01:19:50 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, 0 from numbers(50) on instance (cluster.py:3455, query) 2025-06-04 01:19:50 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT number, 1 from numbers(50) on instance (cluster.py:3455, query) 2025-06-04 01:19:50 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT number, 2 from numbers(50) on instance (cluster.py:3455, query) 2025-06-04 01:19:51 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT number, 3 from numbers(50) on instance (cluster.py:3455, query) 2025-06-04 01:19:51 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT number, 4 from numbers(50) on instance (cluster.py:3455, query) 2025-06-04 01:19:51 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:19:51 [ 515 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-04 01:19:52 [ 515 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-04 01:19:52 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT 50 + number, 0 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-04 01:19:52 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT 50 + number, 1 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-04 01:19:52 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT 50 + number, 2 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-04 01:19:52 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT 50 + number, 3 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-04 01:19:53 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT 50 + number, 4 from numbers(1000) on instance (cluster.py:3455, query) 2025-06-04 01:19:53 [ 515 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:19:53 [ 515 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-04 01:19:53 [ 515 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-04 01:19:54 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-04 01:19:54 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:19:54 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:19:54 [ 515 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) __________ test_restart_server_while_replication_startup_not_finished __________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_restart_server_while_replication_startup_not_finished(started_cluster): NUM_TABLES = 5 pg_manager.create_and_fill_postgres_tables(NUM_TABLES, 100000) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port ) time.sleep(1) instance.restart_clickhouse() > check_several_tables_are_synchronized(instance, NUM_TABLES) test_postgresql_replica_database_engine_1/test.py:774: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:419: in check_several_tables_are_synchronized check_tables_are_synchronized( helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.2.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000001d2c7fa3 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000efeff34 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x0000000007d33e7c E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x0000000017392aa6 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000001738b92f E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x0000000017386d9a E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000001784d170 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x0000000017849b40 E 8. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:701: std::unique_ptr> std::__function::__policy_invoker> (DB::InterpreterFactory::Arguments const&)>::__call_impl> (DB::InterpreterFactory::Arguments const&)>>(std::__function::__policy_storage const*, DB::InterpreterFactory::Arguments const&) @ 0x000000001784e470 E 9. ./build_docker/./src/Interpreters/InterpreterFactory.cpp:0: DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x00000000177b9ecb E 10. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000017da83ff E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000017da3ef8 E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000195d56b2 E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x00000000195f3d08 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000001d154aa3 E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000001d155312 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x000000001d356fc7 E 17. ./build_docker/./base/poco/Foundation/src/Thread.cpp:46: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x000000001d355290 E 18. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001d35374a E 19. __tsan_thread_start_func @ 0x0000000007068b4f E 20. ? @ 0x00007f1b007e3ac3 E 21. ? @ 0x00007f1b00875850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_1" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_2" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_3" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_4" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query INSERT INTO `postgres_database`.`postgresql_replica_0` SELECT number, number from numbers(100000) on instance Executing query INSERT INTO `postgres_database`.`postgresql_replica_1` SELECT number, number from numbers(100000) on instance Executing query INSERT INTO `postgres_database`.`postgresql_replica_2` SELECT number, number from numbers(100000) on instance Executing query INSERT INTO `postgres_database`.`postgresql_replica_3` SELECT number, number from numbers(100000) on instance Executing query INSERT INTO `postgres_database`.`postgresql_replica_4` SELECT number, number from numbers(100000) on instance Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:True cmd: ['bash', '-c', 'ps -C clickhouse'] Command:['docker', 'exec', '-u', 'root', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'ps -C clickhouse'] Stdout: PID TTY TIME CMD Stdout: 8 ? 00:00:10 clickhouse run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', 'pkill clickhouse'] Command:['docker', 'exec', '-u', 'root', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'pkill clickhouse'] run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:8 run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:8 run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:8 run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] No clickhouse process running. Start new one. run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', 'clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon'] Command:['docker', 'exec', '-u', '0', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon'] run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:764 Clickhouse process running. run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] Stdout:764 Executing query select 20 on instance Executing query select 20 on instance Executing query select 20 on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-04 01:19:54 [ 515 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_0` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-04 01:19:56 [ 515 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_1` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-04 01:19:57 [ 515 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_2` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-04 01:19:58 [ 515 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_3` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-04 01:19:59 [ 515 ] DEBUG : Executing query INSERT INTO `postgres_database`.`postgresql_replica_4` SELECT number, number from numbers(100000) on instance (cluster.py:3455, query) 2025-06-04 01:20:00 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:20:00 [ 515 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-04 01:20:01 [ 515 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-04 01:20:02 [ 515 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:True cmd: ['bash', '-c', 'ps -C clickhouse'] (cluster.py:2046, exec_in_container) 2025-06-04 01:20:02 [ 515 ] DEBUG : Command:['docker', 'exec', '-u', 'root', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'ps -C clickhouse'] (cluster.py:113, run_and_check) 2025-06-04 01:20:02 [ 515 ] DEBUG : Stdout: PID TTY TIME CMD (cluster.py:121, run_and_check) 2025-06-04 01:20:02 [ 515 ] DEBUG : Stdout: 8 ? 00:00:10 clickhouse (cluster.py:121, run_and_check) 2025-06-04 01:20:02 [ 515 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', 'pkill clickhouse'] (cluster.py:2046, exec_in_container) 2025-06-04 01:20:02 [ 515 ] DEBUG : Command:['docker', 'exec', '-u', 'root', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'pkill clickhouse'] (cluster.py:113, run_and_check) 2025-06-04 01:20:02 [ 515 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-04 01:20:02 [ 515 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-04 01:20:02 [ 515 ] DEBUG : Stdout:8 (cluster.py:121, run_and_check) 2025-06-04 01:20:03 [ 515 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-04 01:20:03 [ 515 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-04 01:20:03 [ 515 ] DEBUG : Stdout:8 (cluster.py:121, run_and_check) 2025-06-04 01:20:04 [ 515 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-04 01:20:04 [ 515 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-04 01:20:04 [ 515 ] DEBUG : Stdout:8 (cluster.py:121, run_and_check) 2025-06-04 01:20:05 [ 515 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-04 01:20:05 [ 515 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-04 01:20:05 [ 515 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-04 01:20:05 [ 515 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-04 01:20:05 [ 515 ] DEBUG : No clickhouse process running. Start new one. (cluster.py:3817, start_clickhouse) 2025-06-04 01:20:05 [ 515 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', 'clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon'] (cluster.py:2046, exec_in_container) 2025-06-04 01:20:05 [ 515 ] DEBUG : Command:['docker', 'exec', '-u', '0', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', 'clickhouse server --config-file=/etc/clickhouse-server/config.xml --log-file=/var/log/clickhouse-server/clickhouse-server.log --errorlog-file=/var/log/clickhouse-server/clickhouse-server.err.log --daemon'] (cluster.py:113, run_and_check) 2025-06-04 01:20:06 [ 515 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-04 01:20:06 [ 515 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-04 01:20:06 [ 515 ] DEBUG : Stdout:764 (cluster.py:121, run_and_check) 2025-06-04 01:20:06 [ 515 ] DEBUG : Clickhouse process running. (cluster.py:3828, start_clickhouse) 2025-06-04 01:20:06 [ 515 ] DEBUG : run container_id:roottestpostgresqlreplicadatabaseengine1_instance_1 detach:False nothrow:False cmd: ['bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:2046, exec_in_container) 2025-06-04 01:20:06 [ 515 ] DEBUG : Command:['docker', 'exec', 'roottestpostgresqlreplicadatabaseengine1_instance_1', 'bash', '-c', "ps ax | grep 'clickhouse' | grep -v 'grep' | grep -v 'coproc' | grep -v 'bash -c' | awk '{print $1}'"] (cluster.py:113, run_and_check) 2025-06-04 01:20:06 [ 515 ] DEBUG : Stdout:764 (cluster.py:121, run_and_check) 2025-06-04 01:20:06 [ 515 ] DEBUG : Executing query select 20 on instance (cluster.py:3455, query) 2025-06-04 01:20:07 [ 515 ] DEBUG : Executing query select 20 on instance (cluster.py:3455, query) 2025-06-04 01:20:08 [ 515 ] DEBUG : Executing query select 20 on instance (cluster.py:3455, query) 2025-06-04 01:20:08 [ 515 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:20:08 [ 515 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-04 01:20:09 [ 515 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-04 01:20:09 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-04 01:20:09 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:20:09 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:20:10 [ 515 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) ___________________________ test_single_transaction ____________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_single_transaction(started_cluster): conn = get_postgres_conn( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, database=True, auto_commit=False, ) cursor = conn.cursor() table_name = "postgresql_replica_0" create_postgres_table(cursor, table_name) conn.commit() pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port ) assert_nested_table_is_created(instance, table_name) for query in queries: print("query {}".format(query)) cursor.execute(query.format(0)) time.sleep(5) result = instance.query(f"select count() from test_database.{table_name}") # no commit yet assert int(result) == 0 conn.commit() > check_tables_are_synchronized(instance, table_name) test_postgresql_replica_database_engine_1/test.py:531: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.2.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000001d2c7fa3 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000efeff34 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x0000000007d33e7c E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x0000000017392aa6 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000001738b92f E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x0000000017386d9a E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000001784d170 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x0000000017849b40 E 8. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:701: std::unique_ptr> std::__function::__policy_invoker> (DB::InterpreterFactory::Arguments const&)>::__call_impl> (DB::InterpreterFactory::Arguments const&)>>(std::__function::__policy_storage const*, DB::InterpreterFactory::Arguments const&) @ 0x000000001784e470 E 9. ./build_docker/./src/Interpreters/InterpreterFactory.cpp:0: DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x00000000177b9ecb E 10. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000017da83ff E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000017da3ef8 E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000195d56b2 E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x00000000195f3d08 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000001d154aa3 E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000001d155312 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x000000001d356fc7 E 17. ./build_docker/./base/poco/Foundation/src/Thread.cpp:46: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x000000001d355290 E 18. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001d35374a E 19. __tsan_thread_start_func @ 0x0000000007068b4f E 20. ? @ 0x00007f1b007e3ac3 E 21. ? @ 0x00007f1b00875850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database query INSERT INTO postgresql_replica_{} select i, i from generate_series(0, 10000) as t(i); query DELETE FROM postgresql_replica_{} WHERE (value*value) % 3 = 0; query UPDATE postgresql_replica_{} SET value = value - 125 WHERE key % 2 = 0; query UPDATE postgresql_replica_{} SET key=key+20000 WHERE key%2=0 query INSERT INTO postgresql_replica_{} select i, i from generate_series(40000, 50000) as t(i); query DELETE FROM postgresql_replica_{} WHERE key % 10 = 0; query UPDATE postgresql_replica_{} SET value = value + 101 WHERE key % 2 = 1; query UPDATE postgresql_replica_{} SET key=key+80000 WHERE key%2=1 query DELETE FROM postgresql_replica_{} WHERE value % 2 = 0; query UPDATE postgresql_replica_{} SET value = value + 2000 WHERE key % 5 = 0; query INSERT INTO postgresql_replica_{} select i, i from generate_series(200000, 250000) as t(i); query DELETE FROM postgresql_replica_{} WHERE value % 3 = 0; query UPDATE postgresql_replica_{} SET value = value * 2 WHERE key % 3 = 0; query UPDATE postgresql_replica_{} SET key=key+500000 WHERE key%2=1 query INSERT INTO postgresql_replica_{} select i, i from generate_series(1000000, 1050000) as t(i); query DELETE FROM postgresql_replica_{} WHERE value % 9 = 2; query UPDATE postgresql_replica_{} SET key=key+10000000 query UPDATE postgresql_replica_{} SET value = value + 2 WHERE key % 3 = 1; query DELETE FROM postgresql_replica_{} WHERE value%5 = 0; Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select count() from test_database.postgresql_replica_0 on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-04 01:20:10 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:20:10 [ 515 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-04 01:20:10 [ 515 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-04 01:20:10 [ 515 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:20:16 [ 515 ] DEBUG : Executing query select count() from test_database.postgresql_replica_0 on instance (cluster.py:3455, query) 2025-06-04 01:20:17 [ 515 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:20:17 [ 515 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-04 01:20:17 [ 515 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-04 01:20:18 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-04 01:20:18 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:20:18 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:20:18 [ 515 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) __________________________ test_table_schema_changes ___________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_table_schema_changes(started_cluster): NUM_TABLES = 5 for i in range(NUM_TABLES): pg_manager.create_postgres_table( f"postgresql_replica_{i}", template=postgres_table_template_2 ) instance.query( f"INSERT INTO postgres_database.postgresql_replica_{i} SELECT number, {i}, {i}, {i} from numbers(25)" ) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, ) for i in range(NUM_TABLES): instance.query( f"INSERT INTO postgres_database.postgresql_replica_{i} SELECT 25 + number, {i}, {i}, {i} from numbers(25)" ) > check_several_tables_are_synchronized(instance, NUM_TABLES) test_postgresql_replica_database_engine_1/test.py:371: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:419: in check_several_tables_are_synchronized check_tables_are_synchronized( helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.2.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000001d2c7fa3 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000efeff34 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x0000000007d33e7c E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x0000000017392aa6 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000001738b92f E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x0000000017386d9a E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000001784d170 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x0000000017849b40 E 8. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:701: std::unique_ptr> std::__function::__policy_invoker> (DB::InterpreterFactory::Arguments const&)>::__call_impl> (DB::InterpreterFactory::Arguments const&)>>(std::__function::__policy_storage const*, DB::InterpreterFactory::Arguments const&) @ 0x000000001784e470 E 9. ./build_docker/./src/Interpreters/InterpreterFactory.cpp:0: DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x00000000177b9ecb E 10. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000017da83ff E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000017da3ef8 E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000195d56b2 E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x00000000195f3d08 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000001d154aa3 E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000001d155312 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x000000001d356fc7 E 17. ./build_docker/./base/poco/Foundation/src/Thread.cpp:46: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x000000001d355290 E 18. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001d35374a E 19. __tsan_thread_start_func @ 0x0000000007068b4f E 20. ? @ 0x00007f1b007e3ac3 E 21. ? @ 0x00007f1b00875850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_1" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_2" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_3" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_4" ( key Integer NOT NULL, value1 Integer, value2 Integer, value3 Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, 0, 0, 0 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT number, 1, 1, 1 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT number, 2, 2, 2 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT number, 3, 3, 3 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT number, 4, 4, 4 from numbers(25) on instance Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT 25 + number, 0, 0, 0 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT 25 + number, 1, 1, 1 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT 25 + number, 2, 2, 2 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT 25 + number, 3, 3, 3 from numbers(25) on instance Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT 25 + number, 4, 4, 4 from numbers(25) on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-04 01:20:18 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, 0, 0, 0 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:20:19 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT number, 1, 1, 1 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:20:19 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT number, 2, 2, 2 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:20:19 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT number, 3, 3, 3 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:20:20 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT number, 4, 4, 4 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:20:20 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:20:20 [ 515 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-04 01:20:20 [ 515 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-04 01:20:20 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT 25 + number, 0, 0, 0 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:20:21 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_1 SELECT 25 + number, 1, 1, 1 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:20:21 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_2 SELECT 25 + number, 2, 2, 2 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:20:21 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_3 SELECT 25 + number, 3, 3, 3 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:20:21 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_4 SELECT 25 + number, 4, 4, 4 from numbers(25) on instance (cluster.py:3455, query) 2025-06-04 01:20:21 [ 515 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:20:22 [ 515 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-04 01:20:22 [ 515 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-04 01:20:22 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-04 01:20:22 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:20:23 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:20:23 [ 515 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) ___________________________ test_user_managed_slots ____________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_user_managed_slots(started_cluster): slot_name = "user_slot" table_name = "test_table" pg_manager.create_and_fill_postgres_table(table_name) replication_connection = get_postgres_conn( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, database=True, replication=True, auto_commit=True, ) snapshot = create_replication_slot(replication_connection, slot_name=slot_name) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, settings=[ f"materialized_postgresql_replication_slot = '{slot_name}'", f"materialized_postgresql_snapshot = '{snapshot}'", ], ) > check_tables_are_synchronized(instance, table_name) test_postgresql_replica_database_engine_1/test.py:865: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.2.3:9000. DB::Exception: Unknown table expression identifier 'test_database.test_table' in scope SELECT * FROM `test_database.test_table` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000001d2c7fa3 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000efeff34 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x0000000007d33e7c E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x0000000017392aa6 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000001738b92f E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x0000000017386d9a E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000001784d170 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x0000000017849b40 E 8. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:701: std::unique_ptr> std::__function::__policy_invoker> (DB::InterpreterFactory::Arguments const&)>::__call_impl> (DB::InterpreterFactory::Arguments const&)>>(std::__function::__policy_storage const*, DB::InterpreterFactory::Arguments const&) @ 0x000000001784e470 E 9. ./build_docker/./src/Interpreters/InterpreterFactory.cpp:0: DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x00000000177b9ecb E 10. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000017da83ff E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000017da3ef8 E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000195d56b2 E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x00000000195f3d08 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000001d154aa3 E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000001d155312 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x000000001d356fc7 E 17. ./build_docker/./base/poco/Foundation/src/Thread.cpp:46: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x000000001d355290 E 18. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001d35374a E 19. __tsan_thread_start_func @ 0x0000000007068b4f E 20. ? @ 0x00007f1b007e3ac3 E 21. ? @ 0x00007f1b00875850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.test_table` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "test_table" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) user_slot 0/82C2058 000000DA-00000002-1 Checking table test_table exists in test_database Checking table is synchronized: test_database.test_table ----------------------------- Captured stderr call ----------------------------- Executing query INSERT INTO `postgres_database`.`test_table` SELECT number, number from numbers(50) on instance Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') SETTINGS materialized_postgresql_replication_slot = 'user_slot', materialized_postgresql_snapshot = '000000DA-00000002-1' on instance Executing query SHOW DATABASES on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`test_table` order by key; on instance Executing query select * from `test_database.test_table` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-04 01:20:23 [ 515 ] DEBUG : Executing query INSERT INTO `postgres_database`.`test_table` SELECT number, number from numbers(50) on instance (cluster.py:3455, query) 2025-06-04 01:20:23 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:20:23 [ 515 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') SETTINGS materialized_postgresql_replication_slot = 'user_slot', materialized_postgresql_snapshot = '000000DA-00000002-1' on instance (cluster.py:3455, query) 2025-06-04 01:20:24 [ 515 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-04 01:20:24 [ 515 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:20:24 [ 515 ] DEBUG : Executing query select * from `postgres_database`.`test_table` order by key; on instance (cluster.py:3455, query) 2025-06-04 01:20:24 [ 515 ] DEBUG : Executing query select * from `test_database.test_table` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance ---------------------------- Captured log teardown ----------------------------- 2025-06-04 01:20:25 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-04 01:20:25 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:20:25 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:20:25 [ 515 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) _____________________________ test_virtual_columns _____________________________ [gw3] linux -- Python 3.10.12 /usr/bin/python3 started_cluster = def test_virtual_columns(started_cluster): conn = get_postgres_conn( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, database=True, ) cursor = conn.cursor() table_name = "postgresql_replica_0" create_postgres_table(cursor, table_name) pg_manager.create_materialized_db( ip=started_cluster.postgres_ip, port=started_cluster.postgres_port, ) assert_nested_table_is_created(instance, table_name) instance.query( f"INSERT INTO postgres_database.{table_name} SELECT number, number from numbers(10)" ) > check_tables_are_synchronized(instance, table_name) test_postgresql_replica_database_engine_1/test.py:553: _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ helpers/postgres_utility.py:392: in check_tables_are_synchronized result = instance.query(result_query) helpers/cluster.py:3456: in query return self.client.query( helpers/client.py:36: in wrap return func(self, *args, **kwargs) helpers/client.py:74: in query ).get_answer() _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ self = def get_answer(self): self.process.wait(timeout=DEFAULT_QUERY_TIMEOUT) self.stdout_file.seek(0) self.stderr_file.seek(0) stdout = self.stdout_file.read().decode("utf-8", errors="replace") stderr = self.stderr_file.read().decode("utf-8", errors="replace") if ( self.timer is not None and not self.process_finished_before_timeout and not self.ignore_error ): logging.debug(f"Timed out. Last stdout:{stdout}, stderr:{stderr}") raise QueryTimeoutExceedException("Client timed out!") if ( self.process.returncode != 0 or self.remove_trash_from_stderr(stderr) ) and not self.ignore_error: > raise QueryRuntimeException( "Client failed! Return code: {}, stderr: {}".format( self.process.returncode, stderr ), self.process.returncode, stderr, ) E helpers.client.QueryRuntimeException: Client failed! Return code: 60, stderr: Received exception from server (version 24.3.18): E Code: 60. DB::Exception: Received from 172.16.2.3:9000. DB::Exception: Unknown table expression identifier 'test_database.postgresql_replica_0' in scope SELECT * FROM `test_database.postgresql_replica_0` ORDER BY key ASC. Stack trace: E E 0. ./contrib/llvm-project/libcxx/include/exception:141: Poco::Exception::Exception(String const&, int) @ 0x000000001d2c7fa3 E 1. ./build_docker/./src/Common/Exception.cpp:96: DB::Exception::Exception(DB::Exception::MessageMasked&&, int, bool) @ 0x000000000efeff34 E 2. DB::Exception::Exception(int, FormatStringHelperImpl::type, std::type_identity::type>, String const&, String&&) @ 0x0000000007d33e7c E 3. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::(anonymous namespace)::QueryAnalyzer::resolveQuery(std::shared_ptr const&, DB::(anonymous namespace)::IdentifierResolveScope&) @ 0x0000000017392aa6 E 4. ./build_docker/./src/Analyzer/Passes/QueryAnalysisPass.cpp:0: DB::QueryAnalysisPass::run(std::shared_ptr&, std::shared_ptr) @ 0x000000001738b92f E 5. ./build_docker/./src/Analyzer/QueryTreePassManager.cpp:0: DB::QueryTreePassManager::run(std::shared_ptr) @ 0x0000000017386d9a E 6. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:0: DB::(anonymous namespace)::buildQueryTreeAndRunPasses(std::shared_ptr const&, DB::SelectQueryOptions const&, std::shared_ptr const&, std::shared_ptr const&) @ 0x000000001784d170 E 7. ./build_docker/./src/Interpreters/InterpreterSelectQueryAnalyzer.cpp:160: DB::InterpreterSelectQueryAnalyzer::InterpreterSelectQueryAnalyzer(std::shared_ptr const&, std::shared_ptr const&, DB::SelectQueryOptions const&, std::vector> const&) @ 0x0000000017849b40 E 8. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:701: std::unique_ptr> std::__function::__policy_invoker> (DB::InterpreterFactory::Arguments const&)>::__call_impl> (DB::InterpreterFactory::Arguments const&)>>(std::__function::__policy_storage const*, DB::InterpreterFactory::Arguments const&) @ 0x000000001784e470 E 9. ./build_docker/./src/Interpreters/InterpreterFactory.cpp:0: DB::InterpreterFactory::get(std::shared_ptr&, std::shared_ptr, DB::SelectQueryOptions const&) @ 0x00000000177b9ecb E 10. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:302: DB::executeQueryImpl(char const*, char const*, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum, DB::ReadBuffer*) @ 0x0000000017da83ff E 11. ./build_docker/./src/Interpreters/executeQuery.cpp:1376: DB::executeQuery(String const&, std::shared_ptr, DB::QueryFlags, DB::QueryProcessingStage::Enum) @ 0x0000000017da3ef8 E 12. ./contrib/llvm-project/libcxx/include/__memory/shared_ptr.h:612: DB::TCPHandler::runImpl() @ 0x00000000195d56b2 E 13. ./build_docker/./src/Server/TCPHandler.cpp:2341: DB::TCPHandler::run() @ 0x00000000195f3d08 E 14. ./build_docker/./base/poco/Net/src/TCPServerConnection.cpp:57: Poco::Net::TCPServerConnection::start() @ 0x000000001d154aa3 E 15. ./contrib/llvm-project/libcxx/include/__memory/unique_ptr.h:48: Poco::Net::TCPServerDispatcher::run() @ 0x000000001d155312 E 16. ./build_docker/./base/poco/Foundation/src/ThreadPool.cpp:202: Poco::PooledThread::run() @ 0x000000001d356fc7 E 17. ./build_docker/./base/poco/Foundation/src/Thread.cpp:46: Poco::(anonymous namespace)::RunnableHolder::run() @ 0x000000001d355290 E 18. ./base/poco/Foundation/include/Poco/SharedPtr.h:231: Poco::ThreadImpl::runnableEntry(void*) @ 0x000000001d35374a E 19. __tsan_thread_start_func @ 0x0000000007068b4f E 20. ? @ 0x00007f1b007e3ac3 E 21. ? @ 0x00007f1b00875850 E . (UNKNOWN_TABLE) E (query: select * from `test_database.postgresql_replica_0` order by key;) helpers/client.py:239: QueryRuntimeException ---------------------------- Captured stdout setup ----------------------------- PostgreSQL is available - running test ----------------------------- Captured stdout call ----------------------------- Query: CREATE TABLE IF NOT EXISTS "postgresql_replica_0" ( key Integer NOT NULL, value Integer, PRIMARY KEY(key)) Checking table postgresql_replica_0 exists in test_database Checking table postgresql_replica_0 exists in test_database Checking table is synchronized: test_database.postgresql_replica_0 ----------------------------- Captured stderr call ----------------------------- Executing query DROP DATABASE IF EXISTS `test_database` on instance Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Executing query SHOW DATABASES on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, number from numbers(10) on instance Executing query SHOW TABLES FROM `test_database` on instance Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance Executing query select * from `test_database.postgresql_replica_0` order by key; on instance ------------------------------ Captured log call ------------------------------- 2025-06-04 01:20:26 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:20:26 [ 515 ] DEBUG : Executing query CREATE DATABASE `test_database` ENGINE = MaterializedPostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-04 01:20:26 [ 515 ] DEBUG : Executing query SHOW DATABASES on instance (cluster.py:3455, query) 2025-06-04 01:20:26 [ 515 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:20:26 [ 515 ] DEBUG : Executing query INSERT INTO postgres_database.postgresql_replica_0 SELECT number, number from numbers(10) on instance (cluster.py:3455, query) 2025-06-04 01:20:27 [ 515 ] DEBUG : Executing query SHOW TABLES FROM `test_database` on instance (cluster.py:3455, query) 2025-06-04 01:20:27 [ 515 ] DEBUG : Executing query select * from `postgres_database`.`postgresql_replica_0` order by key; on instance (cluster.py:3455, query) 2025-06-04 01:20:27 [ 515 ] DEBUG : Executing query select * from `test_database.postgresql_replica_0` order by key; on instance (cluster.py:3455, query) --------------------------- Captured stderr teardown --------------------------- Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query DROP DATABASE IF EXISTS "postgres_database" on instance Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'stop', '--timeout', '20'] Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_instance_1 ... Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_instance_1 ... done Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done Command:['bash', '-c', '[ -f /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs/stderr.log* || true'] Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'down', '--volumes'] Stderr:Removing roottestpostgresqlreplicadatabaseengine1_instance_1 ... Stderr:Removing roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... Stderr:Removing roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done Stderr:Removing roottestpostgresqlreplicadatabaseengine1_instance_1 ... done Stderr:Removing network roottestpostgresqlreplicadatabaseengine1_default Cleanup called Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine1_.*_1$' --format '{{.ID}}:{{.Names}}' Unstopped containers: {} No running containers for project: roottestpostgresqlreplicadatabaseengine1 Trying to prune unused networks... Trying to prune unused images... Command:['docker', 'image', 'prune', '-f'] Stdout:Total reclaimed space: 0B Images pruned Trying to prune unused volumes... Command:['docker volume ls | wc -l'] Stdout:3 ---------------------------- Captured log teardown ----------------------------- 2025-06-04 01:20:27 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS `test_database` SYNC on instance (cluster.py:3455, query) 2025-06-04 01:20:27 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:20:28 [ 515 ] DEBUG : Executing query DROP DATABASE IF EXISTS "postgres_database" on instance (cluster.py:3455, query) 2025-06-04 01:20:28 [ 515 ] DEBUG : Executing query CREATE DATABASE "postgres_database" ENGINE = PostgreSQL('172.16.2.2:5432', 'postgres_database', 'postgres', 'mysecretpassword') on instance (cluster.py:3455, query) 2025-06-04 01:20:29 [ 515 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'stop', '--timeout', '20'] (cluster.py:113, run_and_check) 2025-06-04 01:20:30 [ 515 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_instance_1 ... (cluster.py:123, run_and_check) 2025-06-04 01:20:30 [ 515 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... (cluster.py:123, run_and_check) 2025-06-04 01:20:30 [ 515 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_instance_1 ... done (cluster.py:123, run_and_check) 2025-06-04 01:20:30 [ 515 ] DEBUG : Stderr:Stopping roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done (cluster.py:123, run_and_check) 2025-06-04 01:20:30 [ 515 ] DEBUG : Command:['bash', '-c', '[ -f /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs/stderr.log ] && zgrep -aH "==================" /ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/logs/stderr.log* || true'] (cluster.py:113, run_and_check) 2025-06-04 01:20:30 [ 515 ] DEBUG : Command:['docker-compose', '--env-file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/.env', '--project-name', 'roottestpostgresqlreplicadatabaseengine1', '--file', '/ClickHouse/tests/integration/test_postgresql_replica_database_engine_1/_instances_0/instance/docker-compose.yml', '--file', '/ClickHouse/tests/integration/helpers/../../../tests/integration/compose/docker_compose_postgres.yml', 'down', '--volumes'] (cluster.py:113, run_and_check) 2025-06-04 01:20:31 [ 515 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine1_instance_1 ... (cluster.py:123, run_and_check) 2025-06-04 01:20:31 [ 515 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... (cluster.py:123, run_and_check) 2025-06-04 01:20:31 [ 515 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine1_postgres1_1 ... done (cluster.py:123, run_and_check) 2025-06-04 01:20:31 [ 515 ] DEBUG : Stderr:Removing roottestpostgresqlreplicadatabaseengine1_instance_1 ... done (cluster.py:123, run_and_check) 2025-06-04 01:20:31 [ 515 ] DEBUG : Stderr:Removing network roottestpostgresqlreplicadatabaseengine1_default (cluster.py:123, run_and_check) 2025-06-04 01:20:31 [ 515 ] DEBUG : Cleanup called (cluster.py:801, cleanup) 2025-06-04 01:20:31 [ 515 ] DEBUG : Docker networks for project roottestpostgresqlreplicadatabaseengine1 are NETWORK ID NAME DRIVER SCOPE (cluster.py:780, print_all_docker_pieces) 2025-06-04 01:20:31 [ 515 ] DEBUG : Docker containers for project roottestpostgresqlreplicadatabaseengine1 are CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES (cluster.py:788, print_all_docker_pieces) 2025-06-04 01:20:31 [ 515 ] DEBUG : Docker volumes for project roottestpostgresqlreplicadatabaseengine1 are DRIVER VOLUME NAME (cluster.py:796, print_all_docker_pieces) 2025-06-04 01:20:31 [ 515 ] DEBUG : Command:docker container list --all --filter name='^/roottestpostgresqlreplicadatabaseengine1_.*_1$' --format '{{.ID}}:{{.Names}}' (cluster.py:113, run_and_check) 2025-06-04 01:20:31 [ 515 ] DEBUG : Unstopped containers: {} (cluster.py:815, cleanup) 2025-06-04 01:20:31 [ 515 ] DEBUG : No running containers for project: roottestpostgresqlreplicadatabaseengine1 (cluster.py:829, cleanup) 2025-06-04 01:20:31 [ 515 ] DEBUG : Trying to prune unused networks... (cluster.py:835, cleanup) 2025-06-04 01:20:31 [ 515 ] DEBUG : Trying to prune unused images... (cluster.py:851, cleanup) 2025-06-04 01:20:31 [ 515 ] DEBUG : Command:['docker', 'image', 'prune', '-f'] (cluster.py:113, run_and_check) 2025-06-04 01:20:31 [ 515 ] DEBUG : Stdout:Total reclaimed space: 0B (cluster.py:121, run_and_check) 2025-06-04 01:20:31 [ 515 ] DEBUG : Images pruned (cluster.py:854, cleanup) 2025-06-04 01:20:31 [ 515 ] DEBUG : Trying to prune unused volumes... (cluster.py:860, cleanup) 2025-06-04 01:20:31 [ 515 ] DEBUG : Command:['docker volume ls | wc -l'] (cluster.py:113, run_and_check) 2025-06-04 01:20:31 [ 515 ] DEBUG : Stdout:3 (cluster.py:121, run_and_check) =============================== warnings summary =============================== test_s3_with_https/test.py::test_s3_with_https[s3_secure] /usr/local/lib/python3.10/dist-packages/urllib3/connectionpool.py:1099: InsecureRequestWarning: Unverified HTTPS request is being made to host '172.16.8.5'. Adding certificate verification is strongly advised. See: https://urllib3.readthedocs.io/en/latest/advanced-usage.html#tls-warnings warnings.warn( -- Docs: https://docs.pytest.org/en/stable/how-to/capture-warnings.html ============================== slowest durations =============================== 300.85s call test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss 49.30s call test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] 48.68s call test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] 41.77s setup test_replication_credentials/test.py::test_credentials_and_no_credentials 41.39s call test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 36.87s call test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 34.79s call test_replicated_mutations/test.py::test_mutations 33.97s setup test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 33.62s setup test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 30.52s setup test_replicated_mutations/test.py::test_mutations 24.87s call test_replicated_user_defined_functions/test.py::test_reload_zookeeper 23.86s call test_replicated_users/test.py::test_reload_zookeeper 23.81s teardown test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore 22.63s teardown test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 22.49s teardown test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] 22.43s teardown test_s3_imds/test_session_token.py::test_credentials_from_metadata 22.00s teardown test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss 21.41s call test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility 21.16s setup test_replicating_constants/test.py::test_different_versions 20.57s setup test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] 20.49s setup test_replicated_user_defined_functions/test.py::test_create_and_drop 19.30s setup test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility 18.80s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper 18.22s setup test_s3_imds/test_session_token.py::test_credentials_from_metadata 16.92s setup test_postgresql_replica_database_engine_1/test.py::test_replicating_dml 16.67s call test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 16.32s setup test_quota/test.py::test_add_remove_interval 15.18s call test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries 14.87s setup test_reloading_settings_from_users_xml/test.py::test_force_reload 14.45s call test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished 14.17s setup test_ssh_keys_authentication/test.py::test_ecdsa 13.94s setup test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries 13.58s teardown test_replication_credentials/test.py::test_same_credentials 10.76s teardown test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 10.47s setup test_render_log_file_name_templates/test.py::test_check_file_names 10.46s teardown test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] 9.72s setup test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss 9.13s teardown test_replicated_users/test.py::test_rename_replicated[USER] 7.78s call test_postgresql_replica_database_engine_1/test.py::test_single_transaction 7.38s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper 7.33s setup test_s3_with_https/test.py::test_s3_with_https[s3_secure] 6.81s teardown test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility 6.66s call test_replicated_user_defined_functions/test.py::test_server_restart 6.61s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper 6.56s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper 6.36s call test_quota/test.py::test_add_remove_interval 5.41s call test_quota/test.py::test_dcl_management 5.21s call test_quota/test.py::test_dcl_introspection 5.09s call test_quota/test.py::test_add_remove_quota 4.98s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity 4.64s teardown test_replicating_constants/test.py::test_different_versions 4.53s teardown test_render_log_file_name_templates/test.py::test_check_file_names 4.52s call test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout 4.45s call test_replication_credentials/test.py::test_different_credentials 4.34s call test_replication_credentials/test.py::test_credentials_and_no_credentials 3.81s teardown test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase 3.75s call test_replication_credentials/test.py::test_same_credentials 3.61s call test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes 3.52s teardown test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout 3.50s teardown test_postgresql_replica_database_engine_1/test.py::test_virtual_columns 3.48s call test_postgresql_replica_database_engine_1/test.py::test_replicating_dml 3.39s call test_replication_credentials/test.py::test_no_credentials 3.36s teardown test_quota/test.py::test_users_xml_is_readonly 3.24s call test_quota/test.py::test_exceed_quota 2.82s call test_replicated_user_defined_functions/test.py::test_replication 2.69s call test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] 2.65s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity 2.46s call test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] 2.25s call test_quota/test.py::test_tracking_quota 2.23s call test_quota/test.py::test_query_inserts 2.11s call test_s3_imds/test_session_token.py::test_credentials_from_metadata 2.03s call test_quota/test.py::test_simpliest_quota 2.00s call test_quota/test.py::test_reload_users_xml_by_timer 1.98s call test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout 1.96s call test_quota/test.py::test_quota_from_users_xml 1.90s teardown test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries 1.83s call test_replicated_user_defined_functions/test.py::test_create_and_replace 1.78s call test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore 1.77s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] 1.71s call test_postgresql_replica_database_engine_1/test.py::test_virtual_columns 1.69s call test_reloading_settings_from_users_xml/test.py::test_force_reload 1.52s call test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation 1.52s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] 1.52s call test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots 1.50s teardown test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] 1.50s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] 1.40s call test_replicated_users/test.py::test_create_replicated[QUOTA] 1.40s call test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum 1.39s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] 1.38s call test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] 1.35s teardown test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] 1.35s call test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] 1.29s call test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] 1.21s setup test_quota/test.py::test_users_xml_is_readonly 1.17s call test_s3_with_https/test.py::test_s3_with_https[s3_secure] 1.15s call test_replicated_users/test.py::test_create_replicated[USER] 1.15s call test_replicated_users/test.py::test_create_replicated[ROW_POLICY] 1.14s call test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload 1.10s call test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] 1.10s call test_replicated_users/test.py::test_create_replicated[ROLE] 1.05s setup test_quota/test.py::test_simpliest_quota 1.03s setup test_quota/test.py::test_dcl_management 1.03s teardown test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 1.01s setup test_quota/test.py::test_tracking_quota 1.01s setup test_quota/test.py::test_quota_from_users_xml 0.99s setup test_quota/test.py::test_add_remove_quota 0.98s setup test_quota/test.py::test_reload_users_xml_by_timer 0.97s call test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int 0.97s call test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase 0.95s setup test_quota/test.py::test_dcl_introspection 0.93s setup test_quota/test.py::test_consumption_of_show_privileges 0.93s call test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] 0.92s call test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] 0.91s teardown test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots 0.90s setup test_quota/test.py::test_query_inserts 0.90s setup test_quota/test.py::test_consumption_of_show_databases 0.89s setup test_quota/test.py::test_exceed_quota 0.89s setup test_quota/test.py::test_consumption_of_show_processlist 0.88s teardown test_postgresql_replica_database_engine_1/test.py::test_single_transaction 0.87s call test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] 0.87s call test_replicated_users/test.py::test_rename_replicated[QUOTA] 0.84s teardown test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes 0.82s call test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] 0.82s setup test_quota/test.py::test_consumption_of_show_tables 0.80s setup test_quota/test.py::test_consumption_of_show_clusters 0.79s teardown test_postgresql_replica_database_engine_1/test.py::test_replicating_dml 0.77s call test_replicated_users/test.py::test_rename_replicated[USER] 0.76s teardown test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished 0.76s call test_replicated_users/test.py::test_rename_replicated[ROLE] 0.73s call test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] 0.72s call test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] 0.71s call test_replicated_user_defined_functions/test.py::test_drop_if_exists 0.68s call test_quota/test.py::test_consumption_of_show_privileges 0.66s setup test_replication_credentials/test.py::test_same_credentials 0.64s setup test_replication_credentials/test.py::test_different_credentials 0.63s call test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] 0.62s call test_ssh_keys_authentication/test.py::test_key_with_passphrase 0.59s call test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] 0.58s setup test_replication_credentials/test.py::test_no_credentials 0.56s call test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] 0.55s call test_replicated_user_defined_functions/test.py::test_create_and_drop 0.55s call test_render_log_file_name_templates/test.py::test_check_file_names 0.53s call test_replicated_users/test.py::test_create_replicated_on_cluster[USER] 0.49s call test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper 0.48s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] 0.48s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] 0.48s call test_quota/test.py::test_consumption_of_show_clusters 0.43s call test_quota/test.py::test_consumption_of_show_databases 0.43s call test_quota/test.py::test_consumption_of_show_processlist 0.43s call test_quota/test.py::test_consumption_of_show_tables 0.43s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] 0.43s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] 0.43s call test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] 0.43s setup test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout 0.38s setup test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int 0.38s call test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] 0.38s call test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] 0.37s setup test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum 0.35s setup test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload 0.33s setup test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout 0.33s call test_replicated_users/test.py::test_create_and_delete_replicated[USER] 0.33s call test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] 0.33s call test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] 0.27s call test_ssh_keys_authentication/test.py::test_ecdsa 0.27s call test_replicating_constants/test.py::test_different_versions 0.22s call test_quota/test.py::test_users_xml_is_readonly 0.22s call test_ssh_keys_authentication/test.py::test_ed25519 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_single_transaction 0.00s setup test_replicated_users/test.py::test_create_and_delete_replicated[USER] 0.00s setup test_replicated_users/test.py::test_rename_replicated[QUOTA] 0.00s teardown test_replicated_mutations/test.py::test_mutations 0.00s setup test_replicated_users/test.py::test_create_replicated[QUOTA] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] 0.00s setup test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] 0.00s setup test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] 0.00s setup test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] 0.00s teardown test_replicated_users/test.py::test_reload_zookeeper 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] 0.00s setup test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] 0.00s teardown test_replicated_user_defined_functions/test.py::test_create_and_drop 0.00s teardown test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] 0.00s setup test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] 0.00s setup test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] 0.00s setup test_replicated_users/test.py::test_create_replicated[ROW_POLICY] 0.00s setup test_replicated_users/test.py::test_create_replicated[USER] 0.00s setup test_replicated_user_defined_functions/test.py::test_drop_if_exists 0.00s setup test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] 0.00s setup test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes 0.00s teardown test_replication_credentials/test.py::test_credentials_and_no_credentials 0.00s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_force_reload 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] 0.00s teardown test_replicated_user_defined_functions/test.py::test_create_and_replace 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_virtual_columns 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum 0.00s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper 0.00s setup test_replicated_user_defined_functions/test.py::test_reload_zookeeper 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] 0.00s teardown test_quota/test.py::test_dcl_introspection 0.00s teardown test_replicated_users/test.py::test_create_replicated[ROLE] 0.00s teardown test_s3_with_https/test.py::test_s3_with_https[s3_secure] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] 0.00s teardown test_quota/test.py::test_tracking_quota 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[USER] 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] 0.00s teardown test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] 0.00s teardown test_quota/test.py::test_simpliest_quota 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] 0.00s setup test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] 0.00s teardown test_replicated_user_defined_functions/test.py::test_drop_if_exists 0.00s setup test_ssh_keys_authentication/test.py::test_ed25519 0.00s setup test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] 0.00s setup test_replicated_user_defined_functions/test.py::test_replication 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] 0.00s setup test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] 0.00s teardown test_quota/test.py::test_reload_users_xml_by_timer 0.00s setup test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload 0.00s setup test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore 0.00s teardown test_ssh_keys_authentication/test.py::test_ecdsa 0.00s setup test_replicated_users/test.py::test_rename_replicated[USER] 0.00s setup test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] 0.00s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper 0.00s teardown test_replicated_user_defined_functions/test.py::test_reload_zookeeper 0.00s setup test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] 0.00s setup test_replicated_users/test.py::test_rename_replicated[ROLE] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[USER] 0.00s setup test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] 0.00s teardown test_quota/test.py::test_consumption_of_show_privileges 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] 0.00s setup test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] 0.00s setup test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[USER] 0.00s teardown test_replicated_users/test.py::test_rename_replicated[QUOTA] 0.00s teardown test_replicated_user_defined_functions/test.py::test_server_restart 0.00s setup test_replicated_users/test.py::test_create_replicated[ROLE] 0.00s setup test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] 0.00s teardown test_quota/test.py::test_add_remove_interval 0.00s setup test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 0.00s teardown test_quota/test.py::test_consumption_of_show_tables 0.00s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] 0.00s teardown test_quota/test.py::test_dcl_management 0.00s teardown test_quota/test.py::test_add_remove_quota 0.00s setup test_replicated_user_defined_functions/test.py::test_create_and_replace 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] 0.00s teardown test_quota/test.py::test_exceed_quota 0.00s setup test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase 0.00s setup test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity 0.00s setup test_replicated_user_defined_functions/test.py::test_server_restart 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] 0.00s setup test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] 0.00s teardown test_replicated_users/test.py::test_create_replicated[USER] 0.00s teardown test_replication_credentials/test.py::test_no_credentials 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] 0.00s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper 0.00s teardown test_replicated_users/test.py::test_create_replicated[ROW_POLICY] 0.00s teardown test_quota/test.py::test_consumption_of_show_processlist 0.00s teardown test_quota/test.py::test_consumption_of_show_clusters 0.00s setup test_replicated_users/test.py::test_reload_zookeeper 0.00s teardown test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] 0.00s teardown test_replication_credentials/test.py::test_different_credentials 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] 0.00s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper 0.00s teardown test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] 0.00s teardown test_quota/test.py::test_consumption_of_show_databases 0.00s setup test_ssh_keys_authentication/test.py::test_key_with_passphrase 0.00s teardown test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] 0.00s teardown test_replicated_user_defined_functions/test.py::test_replication 0.00s teardown test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int 0.00s teardown test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout 0.00s teardown test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] 0.00s teardown test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] 0.00s teardown test_quota/test.py::test_query_inserts 0.00s teardown test_ssh_keys_authentication/test.py::test_key_with_passphrase 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] 0.00s teardown test_quota/test.py::test_quota_from_users_xml 0.00s teardown test_replicated_users/test.py::test_rename_replicated[ROLE] 0.00s teardown test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] 0.00s teardown test_replicated_users/test.py::test_create_replicated[QUOTA] 0.00s teardown test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] 0.00s teardown test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] 0.00s teardown test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation 0.00s teardown test_ssh_keys_authentication/test.py::test_ed25519 0.00s teardown test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper =========================== short test summary info ============================ FAILED test_postgresql_replica_database_engine_1/test.py::test_replicating_dml FAILED test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished FAILED test_postgresql_replica_database_engine_1/test.py::test_single_transaction FAILED test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes FAILED test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots FAILED test_postgresql_replica_database_engine_1/test.py::test_virtual_columns PASSED test_ssh_keys_authentication/test.py::test_ecdsa PASSED test_ssh_keys_authentication/test.py::test_ed25519 PASSED test_ssh_keys_authentication/test.py::test_key_with_passphrase PASSED test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase PASSED test_reloading_settings_from_users_xml/test.py::test_force_reload PASSED test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA] PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop PASSED test_replicated_users/test.py::test_create_and_delete_replicated[ROLE] PASSED test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE] PASSED test_replicated_users/test.py::test_create_and_delete_replicated[USER] PASSED test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0] PASSED test_quota/test.py::test_add_remove_interval PASSED test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum PASSED test_replicated_users/test.py::test_create_replicated[QUOTA] PASSED test_replicated_user_defined_functions/test.py::test_create_and_replace PASSED test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int PASSED test_replicated_users/test.py::test_create_replicated[ROLE] PASSED test_replicated_user_defined_functions/test.py::test_drop_if_exists PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper PASSED test_replicated_users/test.py::test_create_replicated[ROW_POLICY] PASSED test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload PASSED test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE] PASSED test_replicated_users/test.py::test_create_replicated[USER] PASSED test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout PASSED test_s3_with_https/test.py::test_s3_with_https[s3_secure] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA] PASSED test_quota/test.py::test_add_remove_quota PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE] PASSED test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY] PASSED test_quota/test.py::test_consumption_of_show_clusters PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE] PASSED test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA] PASSED test_quota/test.py::test_consumption_of_show_databases PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY] PASSED test_quota/test.py::test_consumption_of_show_privileges PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster[USER] PASSED test_quota/test.py::test_consumption_of_show_processlist PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA] PASSED test_quota/test.py::test_consumption_of_show_tables PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY] PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE] PASSED test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER] PASSED test_quota/test.py::test_dcl_introspection PASSED test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity PASSED test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster] PASSED test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster] PASSED test_replication_credentials/test.py::test_credentials_and_no_credentials PASSED test_quota/test.py::test_dcl_management PASSED test_replicated_user_defined_functions/test.py::test_reload_zookeeper PASSED test_replication_credentials/test.py::test_different_credentials PASSED test_quota/test.py::test_exceed_quota PASSED test_replicated_user_defined_functions/test.py::test_replication PASSED test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation PASSED test_replication_credentials/test.py::test_no_credentials PASSED test_quota/test.py::test_query_inserts PASSED test_quota/test.py::test_quota_from_users_xml PASSED test_replication_credentials/test.py::test_same_credentials PASSED test_replicated_user_defined_functions/test.py::test_server_restart PASSED test_quota/test.py::test_reload_users_xml_by_timer PASSED test_render_log_file_name_templates/test.py::test_check_file_names PASSED test_quota/test.py::test_simpliest_quota PASSED test_replicated_mutations/test.py::test_mutations PASSED test_quota/test.py::test_tracking_quota PASSED test_replicated_users/test.py::test_reload_zookeeper PASSED test_replicated_users/test.py::test_rename_replicated[QUOTA] PASSED test_quota/test.py::test_users_xml_is_readonly PASSED test_replicated_users/test.py::test_rename_replicated[ROLE] PASSED test_replicated_users/test.py::test_rename_replicated[ROW_POLICY] PASSED test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE] PASSED test_replicated_users/test.py::test_rename_replicated[USER] PASSED test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12] PASSED test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore PASSED test_replicated_user_defined_functions/test.py::test_start_without_zookeeper PASSED test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 PASSED test_replicating_constants/test.py::test_different_versions PASSED test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0] PASSED test_s3_imds/test_session_token.py::test_credentials_from_metadata PASSED test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries PASSED test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1] PASSED test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss ============= 6 failed, 94 passed, 1 warning in 401.22s (0:06:41) ============== Traceback (most recent call last): File "/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration/./runner", line 437, in subprocess.check_call(cmd, shell=True) File "/usr/lib/python3.10/subprocess.py", line 369, in check_call raise CalledProcessError(retcode, cmd) subprocess.CalledProcessError: Command 'docker run --rm --name clickhouse_integration_tests_62y5ue --privileged --dns-search='.' --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-odbc-bridge:/clickhouse-odbc-bridge --volume=/home/ubuntu/_work/_temp/test/build/clickhouse:/clickhouse --volume=/home/ubuntu/_work/_temp/test/build/clickhouse-library-bridge:/clickhouse-library-bridge --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/programs/server:/clickhouse-config --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/tests/integration:/ClickHouse/tests/integration --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/backupview:/ClickHouse/utils/backupview --volume=/home/ubuntu/_work/ClickHouse/ClickHouse/utils/grpc-client/pb2:/ClickHouse/utils/grpc-client/pb2 --volume=/run:/run/host:ro --volume=clickhouse_integration_tests_volume:/var/lib/docker -e DOCKER_DOTNET_CLIENT_TAG=11de0b29a15d -e DOCKER_HELPER_TAG=2cffe1eae894 -e DOCKER_BASE_TAG=2993bc2bf171 -e DOCKER_KERBERIZED_HADOOP_TAG=ce74919e88f5 -e DOCKER_KERBEROS_KDC_TAG=9391ecdee8d7 -e DOCKER_MYSQL_GOLANG_CLIENT_TAG=9bec2a638e6e -e DOCKER_MYSQL_JAVA_CLIENT_TAG=766bff31cfe4 -e DOCKER_MYSQL_JS_CLIENT_TAG=41ba7c2ec2a1 -e DOCKER_MYSQL_PHP_CLIENT_TAG=88be89c1e3b6 -e DOCKER_NGINX_DAV_TAG=b55ac9cd7519 -e DOCKER_POSTGRESQL_JAVA_CLIENT_TAG=a4eff5c7f4d6 -e DOCKER_PYTHON_BOTTLE_TAG=a2d3dc777d0c -e DOCKER_CLIENT_TIMEOUT=300 -e COMPOSE_HTTP_TIMEOUT=600 -e PYTHONUNBUFFERED=1 -e PYTEST_ADDOPTS="--dist=loadfile -n 10 -rfEps --run-id=0 --color=no --durations=0 test_postgresql_replica_database_engine_1/test.py::test_replicating_dml test_postgresql_replica_database_engine_1/test.py::test_restart_server_while_replication_startup_not_finished test_postgresql_replica_database_engine_1/test.py::test_single_transaction test_postgresql_replica_database_engine_1/test.py::test_table_schema_changes test_postgresql_replica_database_engine_1/test.py::test_user_managed_slots test_postgresql_replica_database_engine_1/test.py::test_virtual_columns test_quota/test.py::test_add_remove_interval test_quota/test.py::test_add_remove_quota test_quota/test.py::test_consumption_of_show_clusters test_quota/test.py::test_consumption_of_show_databases test_quota/test.py::test_consumption_of_show_privileges test_quota/test.py::test_consumption_of_show_processlist test_quota/test.py::test_consumption_of_show_tables test_quota/test.py::test_dcl_introspection test_quota/test.py::test_dcl_management test_quota/test.py::test_exceed_quota test_quota/test.py::test_query_inserts test_quota/test.py::test_quota_from_users_xml test_quota/test.py::test_reload_users_xml_by_timer test_quota/test.py::test_simpliest_quota test_quota/test.py::test_tracking_quota test_quota/test.py::test_users_xml_is_readonly test_reloading_settings_from_users_xml/test.py::test_force_reload test_reloading_settings_from_users_xml/test.py::test_reload_on_timeout test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_enum test_reloading_settings_from_users_xml/test.py::test_unexpected_setting_int test_reloading_settings_from_users_xml/test.py::test_unknown_setting_force_reload test_reloading_settings_from_users_xml/test.py::test_unknown_setting_reload_on_timeout test_render_log_file_name_templates/test.py::test_check_file_names test_replicated_merge_tree_compatibility/test.py::test_replicated_merge_tree_defaults_compatibility test_replicated_merge_tree_s3_zero_copy/test.py::test_drop_table 'test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[0-16]' 'test_replicated_merge_tree_s3_zero_copy/test.py::test_insert_select_replicated[8192-12]' test_replicated_merge_tree_s3_zero_copy/test.py::test_s3_check_restore test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_default_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_create_replicated_merge_tree_with_not_exists_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_drop_replicated_merge_tree_with_auxiliary_zookeeper test_replicated_merge_tree_with_auxiliary_zookeepers/test.py::test_path_ambiguity test_replicated_mutations/test.py::test_mutations 'test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes0]' 'test_replicated_mutations/test.py::test_mutations_dont_prevent_merges[nodes1]' test_replicated_user_defined_functions/test.py::test_create_and_drop 'test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[false-expected_raise1]' 'test_replicated_user_defined_functions/test.py::test_create_and_drop_udf_on_cluster[true-expected_raise0]' test_replicated_user_defined_functions/test.py::test_create_and_replace test_replicated_user_defined_functions/test.py::test_drop_if_exists test_replicated_user_defined_functions/test.py::test_reload_zookeeper test_replicated_user_defined_functions/test.py::test_replication test_replicated_user_defined_functions/test.py::test_replication_replace_by_another_node_after_creation test_replicated_user_defined_functions/test.py::test_server_restart test_replicated_user_defined_functions/test.py::test_start_without_zookeeper 'test_replicated_users/test.py::test_create_and_delete_replicated[QUOTA]' 'test_replicated_users/test.py::test_create_and_delete_replicated[ROLE]' 'test_replicated_users/test.py::test_create_and_delete_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_create_and_delete_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_and_delete_replicated[USER]' 'test_replicated_users/test.py::test_create_replicated[QUOTA]' 'test_replicated_users/test.py::test_create_replicated[ROLE]' 'test_replicated_users/test.py::test_create_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated[USER]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROLE]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_if_not_exists_on_cluster[USER]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[ROLE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster[USER]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[QUOTA]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROLE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[ROW_POLICY]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_create_replicated_on_cluster_ignore[USER]' 'test_replicated_users/test.py::test_grant_revoke_replicated[With_ignored_on_cluster]' 'test_replicated_users/test.py::test_grant_revoke_replicated[Without_on_cluster]' test_replicated_users/test.py::test_reload_zookeeper 'test_replicated_users/test.py::test_rename_replicated[QUOTA]' 'test_replicated_users/test.py::test_rename_replicated[ROLE]' 'test_replicated_users/test.py::test_rename_replicated[ROW_POLICY]' 'test_replicated_users/test.py::test_rename_replicated[SETTINGS_PROFILE]' 'test_replicated_users/test.py::test_rename_replicated[USER]' test_replicating_constants/test.py::test_different_versions test_replication_credentials/test.py::test_credentials_and_no_credentials test_replication_credentials/test.py::test_different_credentials test_replication_credentials/test.py::test_no_credentials test_replication_credentials/test.py::test_same_credentials test_s3_aws_sdk_has_slightly_unreliable_behaviour/test.py::test_dataloss test_s3_imds/test_session_token.py::test_credentials_from_metadata 'test_s3_with_https/test.py::test_s3_with_https[s3_secure]' 'test_s3_with_https/test.py::test_s3_with_https[s3_secure_with_proxy]' test_s3_zero_copy_ttl/test.py::test_ttl_move_and_s3 test_shutdown_wait_unfinished_queries/test.py::test_shutdown_wait_unfinished_queries test_ssh_keys_authentication/test.py::test_ecdsa test_ssh_keys_authentication/test.py::test_ed25519 test_ssh_keys_authentication/test.py::test_key_with_passphrase test_ssh_keys_authentication/test.py::test_key_with_wrong_passphrase -vvv" altinityinfra/integration-tests-runner:9d492c2eec24 ' returned non-zero exit status 1.